text to multiple columns in xl file wile writing data

dataservices administration
1

Hi All,

I am extracting data from .txt and writing data to ecel file .Once it is loaded its having oneline text perrow with comas.I would like to separate individual columns when ever comas is there.

Pl let me know if any suggestions

kvkumara582 (BOB member since 2009-11-22)

2

Hmmm

Simple!!! Save your text file as a .csv and open it. You will get what you need

ganeshxp :us: (BOB member since 2008-07-17)