Forum Discussion
Change numbers in column to text
Paul, let me illustrate on this simple model
Even better to use Table for the mappings, it's easier to support and not necessary to adjust formulas for expanded ranges or use dynamic ranges formulas.
That could be like
if we name the table as shopNames.
Please check in attached file.
Paul, if you have separate table which maps shop numbers and names, you may VLOOKUP or INDEX/MATCH it to return names into the main table.
If Excel has no idea about such mapping, when manually - Ctrl+H and change one number by another.
Thanks for your answer.
I created a table with our shops and try to use the formula.
It fails, how should i use this formula?
=index(matrix with shops;match(number;numbers of shops;0))
I get the result of the shops in a row, but it doesn't convert the numbers into the name of the shops. What am i missing?
Greetings,
Paul
Paul, let me illustrate on this simple model
Even better to use Table for the mappings, it's easier to support and not necessary to adjust formulas for expanded ranges or use dynamic ranges formulas.
That could be like
if we name the table as shopNames.
Please check in attached file.
Paul, glad to help