How to Add letter before and after of a word?

[najim_uddin]

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.  

[#2 · Accepted solution]

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

[#3]

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

But I failed. Can you help me with this?

[#4]

@najim_uddin 

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

[#5]

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