Merge column into a single cell

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

J.E. McGimpsey has an =MultiCat() that works like =sum() works with numbers:
http://mcgimpsey.com/excel/udfs/multicat.html

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

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
>
> --
> Gmoney
> ------------------------------------------------------------------------
> Gmoney's Profile: http://www.excelforum.com/member.php...o&userid=34465
> View this thread: http://www.excelforum.com/showthread...hreadid=542249

--

Dave Peterson

J.E. McGimpsey has an =MultiCat() that works like =sum() works with numbers:
http://mcgimpsey.com/excel/udfs/multicat.html

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

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
>
> --
> Gmoney
> ------------------------------------------------------------------------
> Gmoney's Profile: http://www.excelforum.com/member.php...o&userid=34465
> View this thread: http://www.excelforum.com/showthread...hreadid=542249

--

Dave Peterson

Woked like a charm!!

Thanks Dave,
Gab