Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Remove Text in a specific Column

Hi, Need help, how to remove the Ms, Mr, Ms. Miss in some of the names of this column in Power Query? Thank you  
Need Help
  • Mikelytics's avatar
    Mikelytics
    3 years ago

    Hi Anonymous 

     

    Please fo the following

    Please also make sure to use a space behind Ms or Mrs.

     

    Best regards
    Michael
    -----------------------------------------------------
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    Appreciate your thumbs up!
    @ me in replies or I'll lose your thread.

     

Mikelytics's avatar
Mikelytics
Icon for Resident Rockstar rankResident Rockstar
3 years ago

Hi Anonymous 

 

Please fo the following

Please also make sure to use a space behind Ms or Mrs.

 

Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thank you so much for the help.

  • Mikelytics's avatar
    Mikelytics
    Icon for Resident Rockstar rankResident Rockstar
    3 years ago

    Anonymous  Awesome! Thank you for your feedback! 🙂