How do you spit one field containing [name, last name] into two fields-- one
with name and the other with last name.

If there's a comma separating the names, then I'd:

Select the range
Data|Text to columns
Delimited by comma
and plop the output into a couple of unused columns (insert 2 adjacent columns
first???)

eintpc5146 wrote:

How do you spit one field containing [name, last name] into two fields-- one
with name and the other with last name.

--

Dave Peterson

"eintpc5146" wrote in message
...
How do you spit one field containing [name, last name] into two fields--
one
with name and the other with last name.

http://www.lmgtfy.com/?q=splitting+data+in+excel+cells

Text to Columns is your best bet. BUT, if want formulas

=LEFT(A1,FIND(" ",A1)-1) will extract 1st name
=MID(A1,FIND(" ",A1)+1,256) will extract surname.



--
Regards
Dave Hawley
www.ozgrid.com
"eintpc5146" wrote in message
...
How do you spit one field containing [name, last name] into two fields--
one
with name and the other with last name.