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.