Hi, I'm trying to build a macro that will replace a number in a cell with a letter if it falls within a specific range. For example.
I have a list of numbers in Column A which will fall into the following ranges:
1 - 9 = A
10 -19 = B
20 -29 = C
And if they fall within that range the number would be replaced with a letter.
Any ideas how I might achieve this?
Bookmarks