Aug 03 2021 09:21 AM
I have a column of identifying numbers, all different, that I need to add a single letter to the beginning of all of the numbers without changing the specific numbers other than adding the letter. For example, identifying number is 0000018963, I need to add "I" (without the quote marks) to the beginning of every number in the column. Is there an easy way to do this?
Thank you
Dee
Aug 03 2021 09:44 AM
SolutionIf to create new column with them , that's ="I"&A1
Aug 03 2021 11:19 AM
Aug 03 2021 09:44 AM
Solution