Turn a horizontal csv file into a non csv separated vertical

apicius · Post by **apicius** » Tue Jul 31, 2012 8:24 am

Hi

I'm new to the forum but have been a subscribed and occasionally free user for some years.
Now for the first time I have a problem.

I am try to convert a wrapped, comma separated,horizontal list of about 80,000 words into one single line vertical listing.

I could of course do it manually...but thought I'd give the forum a try first.

Thanks in advance.

Apicius.

ak47wong · Post by **ak47wong** » Tue Jul 31, 2012 8:50 am

Perform a Replace operation as follows:

Find what: ,
Replace with: \n

Select Regular expression.
Click Replace All.

apicius · Post by **apicius** » Tue Jul 31, 2012 9:12 am

Hi ak47wong

Firstly,thanks for rapid response, and many thanks for the information...I now have my list.

Thanks again.

Apicius