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