change number rating in text rating in Excel

Q35. In Excel, how do I change the rating numbers to rating labels?

For example, I have Survey responses for a service in coded format (3-Satisfied, 2-Neutral, 1-Not Satisfied) as shown below. For purposes of review, I want to change them to actual labels.

excel change number rating in text rating

To do it in Excel, here is the answer:

a) Enter the formula =CHOOSE(CD5,"NOT SATISFIED","NEUTRAL","SATISFIED") as shown below where CD5 corresponds to the cell that has the coded value.

Copy the formula for the rest of the range as required.

excel excel change number rating in text rating

 

You can find similar Excel Questions and Answer hereunder

1) Can I apply formatting to a number concatenated with a Text?

2) Vba delete entire row if contains certain text in Excel

3) How can I enter a text in a cell with subscript and superscript?

4) Concatenate number with text but keeping in number format in Excel

5) Converting numbers stored as text to numbers via macro in Excel

6) How can I change the meta-data of file (Author, Company Name and the like)?

7) How can I find number of months that has elapsed given 2 dates?

8) Can I determine the number of times a character appears in a cell using formula?

9) How can I generate random numbers between 2 limits?

10) In a Table , how can I add a Total Row that displays the maximum value in a column of numbers?

11) How can I have text autocomplete by typing in a short code for the text?

12) How can I convert Column numbers into Column names for use in range definition?

13) How can I get the day number of the year for a date - for example 5 for Jan 5, 33 for Feb 2?

14) How can I have text autocomplete based on values previously entered in Column?

15) How can I change the Marker size and Marker line color for all the series in a chart?