Way to split First Name and Last Name in one cell into 2 cells?

[t.a.smith]

I have to work on a database where I want to take one cell or field that
contains the First Name AND Last name, and make it so the first name is in
one cell and the last name is in another cell. What is the easiest way to do
that? I'm working in Access 2007, however, I can probably export it to excel
and reimport it necessary. Any ideas?

 

[Graham Mayor]

If you are working in Access or Excel it might help to ask in forums for
those products. This one is for Word, where it would be simple enough to do
provided all the names were strictly forename/surname, uncluttered with
middle names, initials or assorted titles.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[That Guy]

I have to work on a database where I want to take one cell or field that
contains the First Name AND Last name, and make it so the first name is in
one cell and the last name is in another cell.  What is the easiest wayto do
that?  I'm working in Access 2007, however, I can probably export it toexcel
and reimport it necessary. Any ideas?

I realize this is an off subject post but I am curious.

How are the names organized?

FirstnameLastname
Firstname Lastname
Lastname,Firstname

What I am trying to determine is how the names can be delimited.

with a little more info I may be able to help.