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
|