HOW TO CHANGE POSITION OF A WORD IN EXCEL

[Sogbouma]

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

[#2]

Try:
=TRIM(SUBSTITUTE(A1, "(Miss)", ""))&" (Miss)"

[#3 · Accepted solution]

this should help you
=SUBSTITUTE(A1, "(Miss)", "")&" (Miss)"

[#4]

Hello @JMB17,

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

[#5]

Hello @Jihad Al-Jarady,

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