May 12 2020 10:18 PM
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 can see there are various functions which might do that but I can't see how to apply them. the prefix is stored as a name in a separate sheet of the spreadsheet.
Thanks in advance,
Stephen
May 12 2020 10:35 PM
Solution@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.
May 12 2020 10:35 PM
Solution@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.