Separating Full Names into First Middle and Last

S

sandyburleson

If I have a column on my worksheet that has full names, how can I separate
these into First, Middle and Last easily? Thanks.
 
R

Ron Rosenfeld

If I have a column on my worksheet that has full names, how can I separate
these into First, Middle and Last easily? Thanks.
Click to expand...

Data/Text to Columns/
Delimited
Select <space> as the delimiter
--ron
 
Top