E eintpc5146 Apr 29, 2010 #1 How do you spit one field containing [name, last name] into two fields-- one with name and the other with last name.
How do you spit one field containing [name, last name] into two fields-- one with name and the other with last name.
D Dave Peterson Apr 29, 2010 #2 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. Click to expand...
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. Click to expand...
V Victor Delta Apr 29, 2010 #3 eintpc5146 said: How do you spit one field containing [name, last name] into two fields-- one with name and the other with last name. Click to expand... http://www.lmgtfy.com/?q=splitting+data+in+excel+cells
eintpc5146 said: How do you spit one field containing [name, last name] into two fields-- one with name and the other with last name. Click to expand... http://www.lmgtfy.com/?q=splitting+data+in+excel+cells
O ozgrid.com Apr 30, 2010 #4 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.
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.
