View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
WDP WDP is offline
external usenet poster
 
Posts: 6
Default Pull Out Last Name

Hi:

I am looking for a function in Excel to extract the LAST NAME from a cell
that looks like:

Justin Kenney

I want the formula to give me only the last name (ie Kenney)

Can anyone help with a formual (maybe the RIGHT function) that looks RIGHT
TO LEFT for the 1st space...and then gives me everything to the RIGHT of the
space

Thanks
Warren