Forum Discussion

Sogbouma's avatar
Sogbouma
Copper Contributor
Feb 21, 2022
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 ...
excel
  • Jihad Al-Jarady's avatar
    Jihad Al-Jarady
    Feb 21, 2022
    this should help you
    =SUBSTITUTE(A1, "(Miss)", "")&" (Miss)"
JMB17's avatar
JMB17
Bronze Contributor
Feb 21, 2022
Try:
=TRIM(SUBSTITUTE(A1, "(Miss)", ""))&" (Miss)"
Sogbouma's avatar
Sogbouma
Copper Contributor
Feb 21, 2022

Hello JMB17,

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

Resources