Wednesday, May 18, 2005
Splitting first and last names in Excel
I received an email from ExcelTip.com the other day that explained how to separate a column of first and last names into two columns, first and last separately. I knew how to do it conceptually but had never bothered.
Anyway today I was asked that very same question and I was able to explain!
Select the column with the fullnames in it making sure there is an empty column to the right.
Select Data | Text to Columns.
Select Delimited in step 1 and Click Next
Check the space checkbox in step 2 and click Finish.
Voila!
The Excel Guru's Free Tips and Hints.
Welcome
Welcome to the Excel Tips blog. Free Microsoft Excel Tips and Hints designed to increase your productivity.
Advertisement
Subscribe Me
Previous Posts
- Rounding to nearest 5 cents part two
- Design and layout presentation tips for Excel
- Dynamic line graphs that work with zeros in Excel
- Rounding to nearest 5 cents in Excel
- Using the COUNT functions in Excel
- Filtering by the Date field in Excel
- Moving is complete - regular transmission to resum...
- Moving house - no posts for a week
- Two type charting
- Using the Resize property in Excel VBA to change a...
My Blogs and Websites
- Spy Journal Home
- Spy Journal Archives
Personal Blog- Excel Tips Blog
- Blog Tips Blog
- Tech Tips Blog
- Urban Space Novel
- Photo Archive
- Parklife Results
- Parklife Soccer Club Website
- KROSTech LAN Parties
- Jethro Management
- Jethro Consultants
- Oz Bush Poet
Excel Links
- ---RSS Feeds---
- Unofficial Microsoft Office Stuff
- KC on Exchange and Outlook
- Office Zealot
- Automate Excel
- Colo's Excel Junk room
- Daily Dose Of Excel
- The Planning Deskbook
- Excel Pragma
- Andrew's Excel Tips
- ---No RSS Feed---
- Excel Tip
- Mailbarrow
- Experts Exchange
- AJP Excel Information
- Beyond Technology
- Contextures
- ExcelTip
- Mr Excel
- Pearson Software Consulting
- Peltier Technical Services
- John Walkenbach - J-Walk
- Vangelder (wont work in Firefox)
- VBA Express
- xlDynamic
- The Excel Nexus
- Code Net
- Better Solutions
- Excel Business Tools
- Data Pig Technologies
- VBA Express
Other Links
Copyright Notice. All documents and text contained in this web site www.spyjournal.biz and sub pages is copyright material of Jethro Management (c) 2004 unless noted as being copyright material of someone else. No public reproduction of the content on this site in any form is permitted without express written permission.
Unless otherwise expressly stated, all original material of whatever nature created by Tim Miller and included in this weblog and any related pages, including the weblog's archives, is licensed under a Creative Commons License.