View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
nmp nmp is offline
external usenet poster
 
Posts: 11
Default Pull last word from a text string in Excel

Is there a way to pull just the last word from a text string in Excel?

I have a sheet with a column of text descriptions that are various lengths
and the last words in each cell are various lengths. Basically I want
everything to the right of the last space.

Thanks!