How split Full Name fields "FirstName LastName" into 2 different fields/columns?

bleggee
bleggee used Ask the Experts™
on
I have some Excel/CSV data with 1 column "Full Name". I need to split it into 2 columns with First Name and Last Name. Is there an easy way?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Data > Text to columns > Delimited > Space > Finish

Author

Commented:
Nice ! Thanks. Worked like  a charm.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial