Extract Part of Spreadsheet to .txt file

[Geoff Smart]

I have a number of applications where string formulas whithin the S/Sheet generate the data to be loaded into other system.
What i need to know is ....
Is there a way of automatically generating a
.txt file from a section of the original s/sheet.

Currently i have to select the formulas and copy into previously open notepad

 

[Andrew Poulsom]

There's no automatic way (other than writing some VBA code) but you can copy the data to a new workbook and save that workbook as a text file. That will save you having to open Notepad.