SOLVED

Add letter to beginning of number cell

%3CLINGO-SUB%20id%3D%22lingo-sub-2605696%22%20slang%3D%22en-US%22%3EAdd%20letter%20to%20beginning%20of%20number%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2605696%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20column%20of%20identifying%20numbers%2C%20all%20different%2C%20that%20I%20need%20to%20add%20a%20single%20letter%20to%20the%20beginning%20of%20all%20of%20the%20numbers%20without%20changing%20the%20specific%20numbers%20other%20than%20adding%20the%20letter.%20For%20example%2C%20identifying%20number%20is%200000018963%2C%20I%20need%20to%20add%20%22I%22%20(without%20the%20quote%20marks)%20to%20the%20beginning%20of%20every%20number%20in%20the%20column.%20Is%20there%20an%20easy%20way%20to%20do%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3CP%3EDee%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2605696%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2605841%22%20slang%3D%22en-US%22%3ERe%3A%20Add%20letter%20to%20beginning%20of%20number%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2605841%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1119526%22%20target%3D%22_blank%22%3E%40Deeb2018%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20to%20create%20new%20column%20with%20them%20%2C%20that's%20%3D%22I%22%26amp%3BA1%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2606373%22%20slang%3D%22en-US%22%3ERe%3A%20Add%20letter%20to%20beginning%20of%20number%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2606373%22%20slang%3D%22en-US%22%3EThat%20worked.%20I%20was%20trying%20to%20make%20it%20harder%20than%20it%20should%20have%20been.%20Thanks!%3C%2FLINGO-BODY%3E
New 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 (New 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