View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Big John Big John is offline
external usenet poster
 
Posts: 2
Default Splitting one column into two

I have a spreadsheet which contains one column of names, (last name,
first name). I would like to split this into two columns so that I will
have the last name in one column and the first name in another so that I
can use either the first or last name in a mail merge.

Is there way to do this?

Thanks--

BJ