Merging a full column into a single
 

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

Here is my problem: I am trying to merge the content of a large colum
into a single cell. I want the same results as when I use the combinin
formula (ex. =A1&A2&A3...) problem is that a formula can't be longe
then something like 100 characters and Im trying to merge columns whic
contain a few hundred cells. I believe there are a few programs ou
there that do this (Excel Merge, Merge assistant) but I'm not willin
to pay 30 dollars or such a fix. Looking for some help on how to g
about writing a macro for this task.

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

--
Gmone
-----------------------------------------------------------------------
Gmoney's Profile: http://www.excelforum.com/member.php...fo&userid=3446
View this thread: http://www.excelforum.com/showthread.php?threadid=54225

Merging a full column into a single
 

You have a reply at your other post.

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. Looking for some help on how to go
about writing a macro for this task.

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=542251

--

Dave Peterson