take a look he


http://www.mcgimpsey.com/excel/textfiles.html


In article ,
"bavjean" wrote:

Thanks Bernie, but I stated in my message that I already tried that what you
suggested:
I also changed the list seperator character to a comma in my XP's Regional
settings-Number settings.

However, I found article in the MSKB which sort-of told me: NOT POSSIBLE
it is here if you or anyone's interested:

http://support.microsoft.com/default...b;en-us;288839