Forum Discussion
Solved
Add text prefix to numbers stored as text
Hi, I'm a new user. I need to modify a price list which has a column of product codes, numbers stored as text. I want to add a prefix to each number. i.e. original number 12345 to read as AB12345. I...
Stephen_Buckland You can use the formula =CONCATENATE if the data is in the same order as of price list. Otherwise use =Vlookup to get respective text and use the above.
Stephen_Buckland You can use the formula =CONCATENATE if the data is in the same order as of price list. Otherwise use =Vlookup to get respective text and use the above.