View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kitti Kitti is offline
external usenet poster
 
Posts: 6
Default seperating data from one cell to multiple cells?

Hi,
I have a worksheet open that has 250 rows of data, all the data appears in
one cell and is seperated by commas, can anyone tell me how I can get excel
to seperate the data divided by commas into individual cells, having seperate
columns?
Without having to do it one at a time using copy and paste?