View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cathy Cathy is offline
external usenet poster
 
Posts: 104
Default minus first word in column

In Column L, I have a persons first name and last name eg: John Smith. In
column N, I just want the persons last name to appear. I know this must be
an easy formula, but I just cannot figure it out.

I appreciate your help.