View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Separating names

Select the column then:-

data|text to columns

The wizard is fairly intuative

Mike

"Stewart99" wrote:

Can a column of names (last name, first name) be split into two columns, one
for the last nams and the other for the first name?