Need to split first name and surname in Excel? - Katalyst Office - Bookkeeper in Auckland, specialists in Xero and WorkflowMax

Need to split first name and surname in Excel?

Home » Need to split first name and surname in Excel?
Share on facebook
Facebook
Share on google
Google+
Share on twitter
Twitter
Share on linkedin
LinkedIn
Share on email
Email
Share on facebook
Share on google
Share on twitter
Share on linkedin
Share on email

So you have the following in a single column in Excel:

Glennis Stuckey

Highlight the whole column, then from the Data menu, select Text to Columns.  Select Delimited, then next, then select Space.  This will now be two columns – Super Easy!   :-)

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top