E
eintpc5146
How do you spit one field containing [name, last name] into two fields-- one
with name and the other with last name.
with name and the other with last name.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
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???)
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.
V
Victor Delta
eintpc5146 said: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
O
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.
=LEFT(A1,FIND(" ",A1)-1) will extract 1st name
=MID(A1,FIND(" ",A1)+1,256) will extract surname.