Thread: Editing Text
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
help help is offline
external usenet poster
 
Posts: 67
Default Editing Text

I have a list of names that are printed like this

SMITH,SAM J
CAMPBELL,SUSAN LYNN
JONES,CINDY

I want it to look like this -

Smith, Sam
Campbell, Susan
Jones, Cindy

How do I remove those middle names, put the names in proper form and put a
space after the comma?