Thread: split data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default split data

Look at Data=Text to Columns

"swati" wrote:

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?