|
07-10-2013, 07:39 AM | #2 |
Kind of a mod
Join Date: Aug 2005
Location: Donkey Land
Casino cash: $1676899
|
If you're able to use a separate column for the numbers, then concatenate, it'll be easy.
Column A: 1001001 1001001 1001001 1001001 =A1+1 =A2+1 =A3+1 =A4+1 (fill down) Column B: ="L"&A1 ="L"&A2 (fill down) If you're just trying to get them in there and don't need to keep the formulas, you can then copy and paste values from Column B wherever you need them, then delete. |
Posts: 51,981
|
|
|