software

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. =A1amp;A2amp;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: www.excelforum.com/member.php...oamp;userid=34465
View this thread: www.excelforum.com/showthread...hreadid=542253One solotion which should work:
In B1 put = a1, in B2 put =B1amp;A1 and copy down.

Per Erik

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

gt;
gt;Hey, if anyone can help me out with this it would be greatly
gt;appreciated.
gt;
gt;Here is my problem: I am trying to merge the content of a large column
gt;into a single cell. I want the same results as when I use the combining
gt;formula (ex. =A1amp;A2amp;A3...) problem is that a formula can't be longer
gt;then something like 100 characters and Im trying to merge columns which
gt;contain a few hundred cells. I believe there are a few programs out
gt;there that do this (Excel Merge, Merge assistant) but I'm not willing
gt;to pay 30 dollars or such a fix.
gt;
gt;Any help would be greatly appreciated.
gt;Thanks in Advance !
gt;Gab


Gab,

Check out Laurent Longre’s site. He has a free add in that features
the MCONCAT function which will do exactly what you want.

i.e.

A1:A10 contains 1 - 10.

=MCONCAT(A1:A10,quot;,quot;)

In B1 produces [1,2,3,4,5,6,7,8,9,10]

HTH
Stevewww.rhdatasolutions.com/morefunc/--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=542253
Thanks for the Help guys,

Someone sent me this solution from McGimpsey's site.
Here is the link if anyone is interested (It worked great)
mcgimpsey.com/excel/udfs/multicat.html

Thanks!,
Gab--
Gmoney
------------------------------------------------------------------------
Gmoney's Profile: www.excelforum.com/member.php...oamp;userid=34465
View this thread: www.excelforum.com/showthread...hreadid=542253