Separating Full Names into First Middle and Last

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Concatenate first, middle and last names 1
Formula To Split Name 5
Separate First, Last Names 2
Converting full Names from 1 cell to 2 5
complicated text to column 4
Separate Names 3
separating text from cells 22
separating first and last names 10

Top