Thread: Add comma in last name first name
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Add comma in last name first name
=SUBSTITUTE(A1," ",", ")

so if A1 contains:
Ravenswood James
the formula returns:
Ravenswood, James
--
Gary''s Student - gsnu200858


"Johnnie" wrote:

Currenly, I have lastname firstname in the same cell and need to add a comma
to show lastname, firstname in the same cell. Any suggestions for a formula?
Thank you in advance.
Reply With QuoteReply With Quote