Forum Discussion

ovetteabejuela's avatar
ovetteabejuela
Impactful Individual
8 years ago
Solved

Power Query | Remove last word

Hi Guys & M-Gurus,   How would you remove the last word in a text, actually in my case I'm trying to remove middle names which are placed at the end portion of the name:   <First Name>, <Last Nam...
Need Help
  • Vvelarde's avatar
    Vvelarde
    8 years ago

    ovetteabejuela

     

    Hi, try with AddColumn-Extract :

     

    Delimiter =  (Space)

     

    Regards

     

    Victor

     

Vvelarde's avatar
Vvelarde
Community Champion
8 years ago

ovetteabejuela

 

Hi, try with AddColumn-Extract :

 

Delimiter =  (Space)

 

Regards

 

Victor

 

ovetteabejuela's avatar
ovetteabejuela
Impactful Individual
8 years ago

Thanks Vvelarde, +1 to my learning and I won't forget that, it's already etched in my mind coz I need to.