Thread: split data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
swati swati is offline
external usenet poster
 
Posts: 16
Default split data

I have some data in a column that i need to split in 2 colums. eg..
column a
10 apples
5 peaches
7 books

have to make it like :
column a column b
10 apples
5 peaches
7 books

any way i can do tht?