View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
roadkill roadkill is offline
external usenet poster
 
Posts: 173
Default Split Data in One Column Into Two

Hello,

We have data that is last name first separated by a comma so it looks like
this: "Schmoe, Joe". What we would like to do is take the first name
(currently in column A) and move it over to column B while leaving the last
name in Column A.

Any easy ways to do this without manually going through thousands of records?