Splitting Names into FirstName LastName

  • Thread starter Thread starter Steve McHugh
  • Start date Start date
S

Steve McHugh

I have a sheet with 250 contact names in one column, one
name per row. I want to import them into my Palm PDA, but
that software looks for First Name and Last Name as
separate fields. Any way to split the column into two
columns to capture this information?

Thanks
 
Select all the data and do Data / Text To Columns / Delimited / Space or comma
as delimiter depending on what you have.
 
Thanks a lot. This worked perfectly...
-----Original Message-----
Select all the data and do Data / Text To Columns / Delimited / Space or comma
as delimiter depending on what you have.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

---------------------------------------------------------- ------------------
It's easier to beg forgiveness than ask permission :-)
---------------------------------------------------------- ------------------






---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.560 / Virus Database: 352 - Release Date: 08/01/2004


.
Click to expand...
 
Back
Top