View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ajay ajay is offline
external usenet poster
 
Posts: 43
Default convert one column into many columns

Hi,
The delimiter is at every 9th record..so Excel is converting the 9th, 18th,
27th...cell into next column.

Any more ideas?
thanks.

"JE McGimpsey" wrote:

One way:

Choose Data/Text to Columns/Delimited


In article ,
Ajay wrote:

Hi,
I have a column which contains data that shd go into 9columns.

can anybody tell me how to convert this single column into 9 columns? I have
a delimiter at every 9th record.

thanks,
Ajay