View Single Post
 
Old 03-24-2015, 09:13 AM
shilabrow shilabrow is offline Windows Vista Office 2007
Advanced Beginner
 
Join Date: Apr 2014
Posts: 45
shilabrow is on a distinguished road
Default 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
Reply With Quote