| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autonumber in a cell
I've got a spreadsheet that has multiple values in a cell. i want to use the
substitue formula to autonumber each value in the cell. Please see example for what i'm trying to accomplish Example: Cell A1 100kv, 200kv, 500kv, 1000kv - (1) 100kv, (2) 200kv, (3) 500kv, (4) 1000kv Cell A2 750v, 800v, 1500v, 2000v - (5) 750v, (6) 800v, (7) 1500v, (8) 2000v |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| why a reference to an empty cell is not considered empty | Excel Discussion (Misc queries) | |||
| Adding a row to worksheet does not update cell references in another. | Excel Worksheet Functions | |||
| Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
| Cell color based upon cell value | Excel Discussion (Misc queries) | |||
| cell color index comparison | New Users to Excel | |||
Linear Mode
