SOLVED

Add letter to beginning of number cell

Copper Contributor

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

3 Replies
best response confirmed by Deeb2018 (Copper Contributor)
Solution

@Deeb2018 

If to create new column with them , that's ="I"&A1

That worked. I was trying to make it harder than it should have been. Thanks!

@Deeb2018 , you are welcome

1 best response

Accepted Solutions
best response confirmed by Deeb2018 (Copper Contributor)
Solution

@Deeb2018 

If to create new column with them , that's ="I"&A1

View solution in original post