SOLVED

HOW TO CHANGE POSITION OF A WORD IN EXCEL

Occasional Contributor

Hello Everyone,

Please I need assistance on how I can change the position of one word in a cell. For example, I have

Chilly Charly (Miss) Berry

Bobby Bop (Miss) Blake

John (Miss) Doe

And I want to change the position of (Miss) to the last position to look like this

Chilly Charly Berry (Miss)

Bobby Bop Blake (Miss) 

John Doe (Miss) 

Thank you

4 Replies
Try:
=TRIM(SUBSTITUTE(A1, "(Miss)", ""))&" (Miss)"
best response confirmed by Sogbouma (Occasional Contributor)
Solution
this should help you
=SUBSTITUTE(A1, "(Miss)", "")&" (Miss)"

Hello @JMB17,

Thank you very much for the tip. Your suggestion was very helpful

Hello @Jihad Al-Jarady,

I truly appreciate your response. It solved my problem. Thank you very much