View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Seymog60 Seymog60 is offline
external usenet poster
 
Posts: 1
Default Splitting a column

I have a date stream that has a column that has "19 x 25", and "26 x 40" and
various different numbers seperated by " x ". I need to seperate the one
column into 2 columns and delete the " x " in the middle of the numbers. Is
there a way to do this automatically instead of manually?