CVS data from one cell into several

[JeanW]

Hi all,

I have an Excel file with comma separated data in cel Ax, going down to 900+ rows.

To have it easy to import the data into another program, I need each cvs part into separated cells.
Parts can vary from 4 to 7 between commas.

Ex.
A1 has data xxx,yyyyy,zzzzz
I need xxx in cel K1
yyyyy in cell L1
zzzzz in cell M1
etc

and that for all the rows.

Any idea for a general macro to do that, because I need to do that somewhat every 2 weeks on given Excel files.

TIA

 

[SkipVought]

hi

check out Data > Text to columns >> Delimited > COMMA

when you figure it out, turn on your macor recorder.

If you need help customizing your recorded code, post in forum707.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[randy700]

How about Text to Columns?


Randy

 

[JeanW]

Thanks. Works like a charm.

Didn't even know that function exist.

But then, I nearly never use Excel, only when forced to....

Tx