One solotion which should work:
In B1 put = a1, in B2 put =B1&A1 and copy down.

Per Erik

On Mon, 15 May 2006 15:00:09 -0500, Gmoney
wrote:


Hey, if anyone can help me out with this it would be greatly
appreciated.

Here is my problem: I am trying to merge the content of a large column
into a single cell. I want the same results as when I use the combining
formula (ex. =A1&A2&A3...) problem is that a formula can't be longer
then something like 100 characters and Im trying to merge columns which
contain a few hundred cells. I believe there are a few programs out
there that do this (Excel Merge, Merge assistant) but I'm not willing
to pay 30 dollars or such a fix.

Any help would be greatly appreciated.
Thanks in Advance :) !
Gab