| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Merging a ton of cells
basically i have a worksheet that starts with number 5120001 and each
cell thereafter increases by one. i want to group these numbers into 20 numbers in each cell. ie. A1 would look like: ----- 5120001 5120002 5120003 5120004 5120005 etc ------ is there anyway i could do this and automate the process so i wouldn't have to do it manually for 20,000 cells? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Merging a ton of cells
This is an unusual request, and it's implementation will render the data
difficult to deal with thereafter. Unless you specifically need this solution to some end, there may be a better way to accomplish your final goal. Could you give us a description of what it is? Vaya con Dios, Chuck, CABGx3 " wrote: basically i have a worksheet that starts with number 5120001 and each cell thereafter increases by one. i want to group these numbers into 20 numbers in each cell. ie. A1 would look like: ----- 5120001 5120002 5120003 5120004 5120005 etc ------ is there anyway i could do this and automate the process so i wouldn't have to do it manually for 20,000 cells? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Merging cells with the same values | Excel Discussion (Misc queries) | |||
| Merging Two Cells and Keeping the Values | Excel Discussion (Misc queries) | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
| Merging cells with text as one line | Excel Worksheet Functions | |||
| Merging Cells | Excel Worksheet Functions | |||
Hybrid Mode
