| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Merging a full 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 -- Gmoney ------------------------------------------------------------------------ Gmoney's Profile: http://www.excelforum.com/member.php...o&userid=34465 View this thread: http://www.excelforum.com/showthread...hreadid=542253 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| run a macro in a locked cell | Excel Discussion (Misc queries) | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| 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 | |||
| How can I combine IF, COLUMN, and LARGE formulas in a single cell? | Excel Worksheet Functions | |||
Threaded Mode
