SOLVED

How to Add letter before and after of a word?

%3CLINGO-SUB%20id%3D%22lingo-sub-2397570%22%20slang%3D%22en-US%22%3EHow%20to%20Add%20letter%20before%20and%20after%20of%20a%20word%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2397570%22%20slang%3D%22en-US%22%3E%3CP%3EGreetings%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20list%20of%20200%20item%20code.%20What%20I%20wish%20to%20do%20is%20adding%20the%20letter%3CSTRONG%3E%20T%3C%2FSTRONG%3E%20before%20the%20word%20and%20adding%20the%20letter%20%3CSTRONG%3EA%3C%2FSTRONG%3E%20after%20the%20word.%20%3CSTRONG%3EFor%20example%3C%2FSTRONG%3E%2C%20Cell%20A1%20is%20item%20code%2C%20having%20the%20value%20%3CSTRONG%3ELUCIOVIOLET%2C%26nbsp%3B%3C%2FSTRONG%3Eadding%20T%20and%20A%20before%20and%20after%20the%20word%2C%20it%20would%20be%20%3CSTRONG%3ETLUCIOVIOLETA%3C%2FSTRONG%3E.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eit%20should%20be%20dynamic.%20Can%20anyone%20help%20me%20out%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETHANKS%20IN%20ADVANCE.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2397570%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2397668%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20Add%20letter%20before%20and%20after%20of%20a%20word%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2397668%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1064611%22%20target%3D%22_blank%22%3E%40najim_uddin%3C%2FA%3E%26nbsp%3BThat%20could%20be%20like%26nbsp%3B%3CSTRONG%3E%3D%22T%22%26amp%3BA1%26amp%3B%22A%22%3C%2FSTRONG%3E%20and%20copy%20down.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2397695%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20Add%20letter%20before%20and%20after%20of%20a%20word%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2397695%22%20slang%3D%22en-US%22%3EThanks%2C%20It%20worked.%20but%20I%20was%20trying%20to%20incorporate%20to%20this%20formula%3A%20%3DSUBSTITUTE(A1%2C%20%22%20%22%2C%22%22)%3CBR%20%2F%3E%3CBR%20%2F%3EBut%20I%20failed.%20Can%20you%20help%20me%20with%20this%3F%3C%2FLINGO-BODY%3E
Occasional Contributor

Greetings, 

 

I have a list of 200 item code. What I wish to do is adding the letter T before the word and adding the letter A after the word. For example, Cell A1 is item code, having the value LUCIOVIOLET, adding T and A before and after the word, it would be TLUCIOVIOLETA

 

it should be dynamic. Can anyone help me out? 

 

THANKS IN ADVANCE.  

4 Replies
best response confirmed by najim_uddin (Occasional Contributor)
Solution

@najim_uddin That could be like ="T"&A1&"A" and copy down.

Thanks, It worked. but I was trying to incorporate to this formula: =SUBSTITUTE(A1, " ","")

But I failed. Can you help me with this?

@najim_uddin 

 

="T"&SUBSTITUTE(A1," ","")&"A"

 

 

Thanks, @Riny_van_Eekelen, Great support from you. !!