Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Breaking out Sections of Names 2

Status
Not open for further replies.

Scott02

Technical User
Jun 4, 2002
75
US
I have a list of names typed in Last, First format within a single column in Excel. Now someone is wanting to separate first and last name to use in mail merge. It would probably be best to break them out into individual columns. Can anyone help with this? Thanks in advance!

Example
Column A
Doe, John A.

Need:
Col. A Col. B
John A. Doe


Scott
 
Select your column of data and then do:-

Data / Text to Columns / Delimited / Tick 'Space' as delimiter, and make sure you have empty columns to teh right of your data.

Regards
Ken............
 
Ken, Worked like a charm. Thanks for your help. I really appreciate it.

Scott
 
Don't miss the bit where you tick the 'space' option. This has a bunch of other possible delimiters, and if they aren't enough you can even put in your own in the'other' box. So for example, if you had 23/12/1999 as text, you could split that up into 23 12 1999 in separate columns.

Regards
Ken...............
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top