First name, Last name in seperate columns

  • Thread starter Thread starter Capt_Trips
  • Start date Start date
C

Capt_Trips

Hello,
I have a very large spreadsheet with customer information...Company,
Name, Address, City, etc etc...The problem is that Name is first name
and last name in one column...I would like to have first name in one
column and last name in another. Is there any way to do this without
copying and pasting 25,000 names?
Any help would save me days of work
Thanks
John
 
Insert a column at B.
Select column A.
Data>Text To Columns and use a delimiter of space.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 
You must log in or register to reply here.

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

VBA - retrieve data on last create named range from previous inserted named range 0
change first name last name to last name first name 3
Search two columns in list for first and last name and return Id 4
How do I separate first and last names into two columns? 2
how to arrange list by first or last name 1
formulate email address based on last name & first letter of first 1
Matching Names 5
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0

Back
Top