Create two columns from a single column with (first and last name)
 

Good morning all,
Is there a way to create two columns from one name field? Any help?
Thanks,
KB

Create two columns from a single column with (first and last name)
 

DataText To Columns, delimiter of space.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"KB" wrote in message
...

Good morning all,
Is there a way to create two columns from one name field? Any help?
Thanks,
KB

Create two columns from a single column with (first and last name)
 

For a more general approach that handles multiple first names (John Quincy
Adams), see
www.mirecki.us/computing
--
TedMi

"KB" wrote:


Good morning all,
Is there a way to create two columns from one name field? Any help?
Thanks,
KB