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
 

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

Mail Merge Directory Conditional Page Break 0
Format column widths from one table to a separate table on same page 1
Grouping Names in Mail Merge 0
Style Header Reformatted 3
Setting up and synchronizing Outlook calendars on iPhone 0
Merge Excel file into Word Document 3
Combining three files when middle file has sections with endnotes 2
Quick Parts / SharePoint Library Update 0

Top