View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default Add comma in last name first name

ctrl+H

replace " " by ", "

the quotes are just to show the space.

hth
--
pleae click yes if it was helpfull
regards from Brazil
Marcelo



"Johnnie" escreveu:

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.