View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mjcam349 mjcam349 is offline
external usenet poster
 
Posts: 1
Default Reorgainizing Data

In my spreadsheet I have a column that list many names. The format is:
first name <space last name. I want to reformat the data into a new cell,
but this time it needs to be: last name, first name.

Is there a easy way to do this?