Exporting to Text file - values separated by lines

[happypyro]

Hi, I'm looking for a way to export a basic worksheet to a txt file but to separate lines. For example I have a worksheet that is formatted like this:

Column A Column B Column C
Dan Cookies 12
Ryan Pies 15

And I need to save it to a text file like this:

Dan
Cookies
12
Ryan
Pies
15

Any help and feedback is appreciated! thank you

[Leon V (AW)]

just make it comma seperated then open the text file and do find replace comma with return ("\n" in notepad++)("^l" in word)

[happypyro]

thank you for your suggestion, I do have a problem in that many of my values include a comma

[abousetta]

Try tab-delimited instead then replace tabs with ^p in MS Word

[Leon V (AW)]

ok then make it tab delimited ("^t" in word)("\t" in notepad++)

you can delimit it with pretty much any character you want anyway See Here

[xlbiznes]

Hi,

You need some code to do that

[Leon V (AW)]

You need some code to do that

I know you could write doing it in Word into a macro but while we are on the subject can excel do find replace as a shell comand in notepad++?

[happypyro]

Thank you all. I'm now saving to tab delimited and opening in Notepad++ where I have a macro set up to find the tabs and replace with Carriage Return and Line Feed:

find \t
replace with \r\n

It would be great to have some code to do it without the extra step but I have no experience with that. thanks

[xlbiznes]

This my solution.

[happypyro]

This my solution.

Thanks! Where does the file output? Im not able to find it...

[xlbiznes]

It would be in the same path of this xlsm file.

[happypyro]

Ah, I opened it from the downloads folder and it got lost. Thanks so much!

[xlbiznes]

You are welcome, glad i could help.

[abousetta]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.