Forum Discussion
Solved
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 ...
- this should help you
=SUBSTITUTE(A1, "(Miss)", "")&" (Miss)"
this should help you
=SUBSTITUTE(A1, "(Miss)", "")&" (Miss)"
=SUBSTITUTE(A1, "(Miss)", "")&" (Miss)"
Hello Jihad Al-Jarady,
I truly appreciate your response. It solved my problem. Thank you very much