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 LU...
najim_uddin That could be like ="T"&A1&"A" and copy down.
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?- Thanks, Riny_van_Eekelen, Great support from you. !!
