View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Seperating First and Last Names

Select your column of names
data|text to columns
delimited, by space

This will work nicely with two names--maybe exactly the way you want with
multiple names.

WilsonLA wrote:

How do I sepearate first and last name to two cells from one cell?


--

Dave Peterson