Forum Discussion
Sogbouma
Feb 21, 2022Copper Contributor
HOW TO CHANGE POSITION OF A WORD IN EXCEL
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
- this should help you
=SUBSTITUTE(A1, "(Miss)", "")&" (Miss)"
4 Replies
- this should help you
=SUBSTITUTE(A1, "(Miss)", "")&" (Miss)"- SogboumaCopper Contributor
Hello Jihad Al-Jarady,
I truly appreciate your response. It solved my problem. Thank you very much
- JMB17Bronze ContributorTry:
=TRIM(SUBSTITUTE(A1, "(Miss)", ""))&" (Miss)"