Forum Discussion
Change numbers in column to text
Hello,
For some of you a simple issue, but for i am struggling for long to do this.
I have two columns which i want to use: the one with numbers of our shops en one with hours people worked an secific month.
So for example:
Shop Hours
01 226
01 224
02 254
Now i want to change the number to the shops into their names. So that 01 will become "Amersfoort".
Because of the very large amount of data i want to automatic this. Anyone an idea how to do this?
Thanks in advance!
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.
5 Replies
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.
