View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Shannon
 
Posts: n/a
Default reformat a cell from last name, first to first space last?

I downloaded a spreadsheet with a column in it containing peoples names.
They are listed with the last name first then a comma and the first name or
first initial. I want to change them to first name and last name sparated by
a space for data base purposes to use in a mailing. Is there any easy way to
do this?