Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merge 1000+ cells into one
Good morning
I am really hoping someone can help me with this. I have a worksheet with 1 column (A) and 1439 rows. I need to combine all 1439 of these cells into one, using the following format: A1 & "" & A2 & "" etc. Naturally, doing this manually would take several hours (and be extremely vulnerable to mistakes.) Is there a method using VBA that I could do this? Thanks for any ideas. Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
divide many cells by 1000 | Excel Discussion (Misc queries) | |||
Dividing multiple cells by 1000 | Excel Worksheet Functions | |||
Divide Cells on a spreadsheet by 1000 | Excel Discussion (Misc queries) | |||
Dividing cells by 1000 | Excel Discussion (Misc queries) | |||
Multiples of 1000 in cells? | Excel Discussion (Misc queries) |