Forum Discussion
Deeb2018
Aug 03, 2021Copper Contributor
Add letter to beginning of number cell
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
If to create new column with them , that's ="I"&A1
3 Replies
- SergeiBaklanDiamond Contributor
If to create new column with them , that's ="I"&A1
- Deeb2018Copper ContributorThat worked. I was trying to make it harder than it should have been. Thanks!
- SergeiBaklanDiamond Contributor
Deeb2018 , you are welcome