I have a large amount of numbers in an Excel spreadsheet that I want to replace with text. It looks something like this:
33
33
33
33
22
21
22
29
49
95
43
23
45
12
11
22
I want all of the 33
's to be replaced with "Clothing", all of the 22
's to be replaced with "House", etc. I have to do this on a day-to-day basis, so I don't want to use the lookup and replace button and go through 43 numbers, replacing them with custom strings.
How can this be automated?