splitting content of a field
How do you spit one field containing [name, last name] into two fields-- one
with name and the other with last name. |
splitting content of a field
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 |
splitting content of a field
"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 |
splitting content of a field
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. |
All times are GMT +1. The time now is 02:41 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com