Add text prefix to numbers stored as text

[Stephen_Buckland]

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

[#2 · Accepted 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.