| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| 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 | |||
Threaded Mode
