SOLVED

How to Add letter before and after of a word?

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. !!