Excel 2007 counting numbers
In B2 put
="MJTB"&1001+(ROWS($B$1:B1)*1001)
copy down 235 rows, select the range and copy and paste special as values in
place
for the second use
="MJTB"&2044+(ROWS($B$1:B1)*1000)
repeat the copy and pasting.
Note that $B$1:B1 has nothing to do with the firs value being in B1 it just
generates row numbers
--
Regards,
Peo Sjoblom
"urlocaljeweler" wrote in message
...
In Excel 2007 I have a question...
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... 235 times....
Any thoughts?
Thank you.
|