Do you think if it will work:

I use "=CONCATENATE" in one cell and allow it to hold 25 cells. In next
cell, I put second "=CONCATENATE" to hold another 25 cells....

So with 20 "=CONCATENATE"s, I can cover all my data, say, from A1:T1.

Then the question will be

Can I save it as CVS file where the entire first row is one record?




mr_ben wrote:
you can daisy chain formulas however you can only nest 7 formulas in one
big formula


As for cell length there is something about more than 1024 characters
(IIRC) being a problem.

unfortunately my VBA skills are sadly lacking so there could be a
better way...


--
mr_ben
------------------------------------------------------------------------
mr_ben's Profile: http://www.excelforum.com/member.php...o&userid=37106
View this thread: http://www.excelforum.com/showthread...hreadid=568446