U
urlocaljeweler
I have a cell in a column B1:
MJTB1001
I need to paste to approximately 235 new rows in the column B1 as follows
MJTB2002
MJTB3003
MJTB4004... etc.
What formula should I use to accomplish this task?
Also I have the cell MJTB2044 and I need to make 235 new cells in column to
fit like this...
MJTB2044
MJTB3044
MJTB4044
MJTB5044 ... etc... until the middle B5=B235 etc...
Thank you.
MJTB1001
I need to paste to approximately 235 new rows in the column B1 as follows
MJTB2002
MJTB3003
MJTB4004... etc.
What formula should I use to accomplish this task?
Also I have the cell MJTB2044 and I need to make 235 new cells in column to
fit like this...
MJTB2044
MJTB3044
MJTB4044
MJTB5044 ... etc... until the middle B5=B235 etc...
Thank you.