SOLVED

HOW TO CHANGE POSITION OF A WORD IN EXCEL

%3CLINGO-SUB%20id%3D%22lingo-sub-3191054%22%20slang%3D%22en-US%22%3EHOW%20TO%20CHANGE%20POSITION%20OF%20A%20WORD%20IN%20EXCEL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3191054%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Everyone%2C%3C%2FP%3E%3CP%3EPlease%20I%20need%20assistance%20on%20how%20I%20can%20change%20the%20position%20of%20one%20word%20in%20a%20cell.%20For%20example%2C%20I%20have%3C%2FP%3E%3CP%3EChilly%20Charly%20(Miss)%20Berry%3C%2FP%3E%3CP%3EBobby%20Bop%20(Miss)%20Blake%3C%2FP%3E%3CP%3EJohn%20(Miss)%20Doe%3C%2FP%3E%3CP%3EAnd%20I%20want%20to%20change%20the%20position%20of%20(Miss)%20to%20the%20last%20position%20to%20look%20like%20this%3C%2FP%3E%3CP%3EChilly%20Charly%20Berry%26nbsp%3B(Miss)%3C%2FP%3E%3CP%3EBobby%20Bop%20Blake%26nbsp%3B(Miss)%26nbsp%3B%3C%2FP%3E%3CP%3EJohn%20Doe%26nbsp%3B(Miss)%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3191054%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3191110%22%20slang%3D%22en-US%22%3ERe%3A%20HOW%20TO%20CHANGE%20POSITION%20OF%20A%20WORD%20IN%20EXCEL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3191110%22%20slang%3D%22en-US%22%3ETry%3A%3CBR%20%2F%3E%3DTRIM(SUBSTITUTE(A1%2C%20%22(Miss)%22%2C%20%22%22))%26amp%3B%22%20(Miss)%22%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3191176%22%20slang%3D%22en-US%22%3ERe%3A%20HOW%20TO%20CHANGE%20POSITION%20OF%20A%20WORD%20IN%20EXCEL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3191176%22%20slang%3D%22en-US%22%3Ethis%20should%20help%20you%3CBR%20%2F%3E%3DSUBSTITUTE(A1%2C%20%22(Miss)%22%2C%20%22%22)%26amp%3B%22%20(Miss)%22%3C%2FLINGO-BODY%3E
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