can I export named ranges into text files with excel ?

Yes this can be done.  Can you attached a sample file?

file with 3 named ranges.  I would like each range to be the title of each text file
ee-filewith3namedranges.xlsx

I am at absolute awe on this solution,  Great Great Great !!!

I am going to award you the points however I have one more optional option.

every time there is a space in my file, it starts a new line

in other words
Hello Word

becomes:
hello
world

Is there a way to keep the lines as they were ?

If it needs to be a csv or what ever that is fine.  This  will work as it is but options are great also

thx again.

Sorry, I don't think I fully understand the issue.

Do you mean that "Hello" & "World" are in two separate cells within a range, or that a single cell within one of the ranges contains the text value of "Hello World" (without the quotes, but with the space character between them)?

If the latter case ("Hello World"), then I am not seeing that with the test data.

For example, these three cell values in a single column:
---
interface3
ip 30
netmask 240
---

Appear in the "output" folder as expected.


Please can you clarify what you mean?  Perhaps attaching an example workbook to demonstrate the problem would be useful.

Thank you.

it will work as done,  
thx

accepting solution, it is a very good one

A as in Awsome !!!