View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Ragdyer
 
Posts: n/a
Default how can I split one cell's data into two cells?

See one comment to your post in the excel group.
Please don't multi-post.
Most responders monitor all the XL groups.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
wrote in message
k.net...
I am using Excel as a database, and have a column with cells with a

person's
name (text) in it...e.g., John Smith. NOW, after the fact, I wish to have

a
column with just John in it, and another column with just Smith...but I

have
NO idea how to do this! Help would be appreciated. Thank you.