View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson
 
Posts: n/a
Default How do i separate full names appearing in single cells?

Select the column
Data|Text to columns
delimited by space

Watch out for those names with more than two parts!

daveylee wrote:

We received an excel spread sheet with full names within a single column. We
need to separate into first and last name columns.


--

Dave Peterson