rjwrig
05-06-2016, 08:31 AM
Hello,
I am looking for some help building a macro that would find and replace numbers with text for different questions on a questionnaire. For example my data file would have each question in a separate column and cell B2 would contain the label for what each response has been coded as numerically e.g.,
0 = [red], 1 = [blue], 2 = [orange], 3 = [yellow]
in the cells below would be a row for each participant and what option they selected (e.g. 0,1,2 or 3). What I need to do is replace the numbers with the corresponding text. Is there anyway to get Excel to look at what the corresponding text is for the different numbers in B2 and use this information to select and replace? It would be great if it would look at what is inside the [] as the text for different questions would be different.
Any help gratefully received. I have an attached an excel file. Column B would be an example of the raw data and what I would like to
be able to do is end up with column F by it looking at the wording in cell B2 0 = [Red], 1 = [Blue], 2 = [Yellow]
Is it possible to refer it to cell B2 and the labeling here in order to recode the column to look like column F? As the questions, and hence the labels will change often.
B2 is how our questions are exported in the raw data so I cant change the format of 0 = [Red], 1 = [Blue], 2 = [Yellow]
B
I am looking for some help building a macro that would find and replace numbers with text for different questions on a questionnaire. For example my data file would have each question in a separate column and cell B2 would contain the label for what each response has been coded as numerically e.g.,
0 = [red], 1 = [blue], 2 = [orange], 3 = [yellow]
in the cells below would be a row for each participant and what option they selected (e.g. 0,1,2 or 3). What I need to do is replace the numbers with the corresponding text. Is there anyway to get Excel to look at what the corresponding text is for the different numbers in B2 and use this information to select and replace? It would be great if it would look at what is inside the [] as the text for different questions would be different.
Any help gratefully received. I have an attached an excel file. Column B would be an example of the raw data and what I would like to
be able to do is end up with column F by it looking at the wording in cell B2 0 = [Red], 1 = [Blue], 2 = [Yellow]
Is it possible to refer it to cell B2 and the labeling here in order to recode the column to look like column F? As the questions, and hence the labels will change often.
B2 is how our questions are exported in the raw data so I cant change the format of 0 = [Red], 1 = [Blue], 2 = [Yellow]
B