View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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