Converting from .txt to .csv (Formatting Issue)....

Hello,

Is it possible to convert a .txt file containing multi-words separated by commas into a .csv file with each word on a row?? I am using Excel 2002. See Example Below.

(I want to go from this) .txt
man, woman, computer, screen, speaker

(to this) .csv
man
woman
computer
screen
speaker

And thanks for any help in advance,
Parsec

Hello

The following will do that:

Please Login or Register  to view this content.

You need to change the file name of the text file that is opened and the csv file that is created. This code goes into a standard module in the VBE (Alt+F11 to open up the VBE and navigate to your workbook in the top left Projects window, right-clik on it and select Insert>Module, paste code into the white area to the right that will open up). Run the macro from Excel eg Tools>Macro>Macros and select it from the list and hit Run.

Richard

PURE GENIUS!!!! THANKS A LOT!!!

Parsec