View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Ethoros Ethoros is offline
external usenet poster
 
Posts: 12
Default Add comma in last name first name

=A1 &" , " & A2

"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.