|
|
#1
03-24-2015, 09:13 AM
|
|||
|
|||
concantenate cells in multiple row
I have about 120,000 of rows with entries in A column . I want to combine all entries in Column A into one cell seperating them by semicolon but l get timed out or excel doesnt capture all in one cell. I need help in getting this done even if Vba. Any and all help will be appreciated. Column A 1. 0088900 2. 0089334 3. 0008994 4. Engen and Sons Until 120000. 0995789 Output = 0088900;0089334;0008994;Engen and Sons;.............until;0995789 All help appeciated 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Get multiple cells in separate worksheet
|
kerkstrt | Excel | 1 | 10-26-2014 11:20 PM |
| Link multiple cells in drop-down lists | Trial4life | Excel | 0 | 09-08-2014 05:08 AM |
| Counting cells with multiple complex criteria | TishyMouse | Excel | 12 | 12-06-2012 05:05 AM |
|
How to merge multiple records into one and update the cells
|
mag | Excel | 1 | 10-30-2012 01:11 AM |
|
Multiple VLOOKUP's checking multiple Cells
|
OTPM | Excel | 11 | 05-23-2011 11:18 AM |
Windows Vista 
Office 2007
Threaded Mode