Forum Discussion
Solved
How to Add letter before and after of a word?
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.
najim_uddin That could be like ="T"&A1&"A" and copy down.
4 Replies
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?
