Need convert from txt file to excel spreed sheet
I have one huge txt file about 1000 row, for example
aaaaaa,"bbbbbbbb","ccccccc"
aaaaaaaaaaaa,"bbbbbbbbbbbbbb","cccccccccccccc"
aa,"bbbb","ccccc"
I need to removed the , and " " in between,
I need put them into excel format
______________________________
aaaaaa |bbbbbbbb |ccccccccc
__________________________________
aaaaaaaaaaa |bbbbbbbbbbb|ccccccccccccc
______________________________________
aa |bbbb |ccccc
_____________________________________
How can I do that with macro, thanks for the help
Lillian
|