598592_en-US

liliconcom

Re: Extracting the Last Word

Right click on the column header you wish to get the value from and create new formula column with Last Word

then you can take a look at the formula if needed

You can also do the extraction with Recode for example

 

Re: Extracting the Last Word

The Word() function is perfect for this. Use "-1" to get the last word.

 

If you learn only one Formula Editor function, Word() is the one 

 

 

 

 

Re: Extracting the Last Word

Thank you!

Extracting the Last Word

Hi - If I want to extract the last word in the Name column below, what would be the best way to so?

 

 

Automation and Scripting