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.
|