User Profile
PaulD98L
Copper Contributor
Joined Dec 12, 2019
User Widgets
Recent Discussions
Re: Change numbers in column to text
SergeiBaklan 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, Paul1.4KViews0likes3CommentsChange 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, PaulSolved1.5KViews0likes5Comments
Recent Blog Articles
No content to show