Thread: Splitting firstName from Surname
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Althea
 
Posts: n/a
Default Splitting firstName from Surname



You could use this formula for surname

=TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",LEN(A1))),LEN(A1)))


Many thanks for all the different suggestions, problem solved
Thanks
Althea


Reply With QuoteReply With Quote