Splitting Names into FirstName LastName

[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

 

[Ken Wright]

Select all the data and do Data / Text To Columns / Delimited / Space or comma
as delimiter depending on what you have.

 

[Steve McHugh]

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


.

 

[Ken Wright]

My pleasure, thanks for letting me know