how2 export a VERY long string out of Excel

I've concat'd together a string of about 6,000 characters, delivered to a single Excel 2003 cell via a VBA function. I now want to copy/paste the string out of Excel for use elsewhere.

Straight copy/paste from the cell delivers the cell formula (the function); copying to another cell using the Value function extracts the string ok but a paste from there only delivers the first portion of it (as expected, given the Excel string-length limits for such operations).

The only way I've been able to grab the whole string is to copy the initial cell (where the function is) and then paste into MS Word where the whole string becomes 'normal' text, and then, sigh, copy/paste from there to the string's final destination. Not so good if it has to be done a hundred times or so.

There has to be a better way, hopefully less ornate than having VBA write the string to a file somewhere. Help appreciated. - Jim

I have no problem doing copy, paste special, values of a full-length (32767-character) string in the user interface and copying the entire string.

Ditto for this, where A15 contains a long string:

Please Login or Register  to view this content.