| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formating Excel Spreed Sheet | Excel Discussion (Misc queries) | |||
| how to increment no on excel spreed sheet | Excel Programming | |||
| How can I read over than 65,536 rows from excel spreed sheet | Excel Discussion (Misc queries) | |||
| Break apart in long excel spreed sheet | Excel Programming | |||
| delete record using Macro in excel spreed sheet | Excel Programming | |||
Linear Mode
