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 |
All times are GMT +1. The time now is 12:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com