splitting content of a field

[eintpc5146]

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

 

[Dave Peterson]

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???)

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

 

[Victor Delta]

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

 

[ozgrid.com]

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.