If you have other data that you need to save on the same sheet, just Select
the range you want to save as text and use the formatcellsNumber tab and
under Categories, click on text. If other users require that range as other
than text then you will need to Save As another filename so the original file
will still be available to other users.

"GFN" wrote:

Is there a way to save a named range as a text file. I have only found how
to save a worksheet as a text file.