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

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.