| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| merging single worksheet files into a single workbook | Excel Discussion (Misc queries) | |||
| Merging a full column into a single cell | Excel Worksheet Functions | |||
| How do i separate full names appearing in single cells? | Excel Worksheet Functions | |||
| Conditional formatting a full row triggered by a single cell | Excel Worksheet Functions | |||
| Conditional formatting a full row triggered by a single cell reference... | Excel Worksheet Functions | |||
Hybrid Mode
