Excel 2007 counting numbers
Since you neglected to show what row 235 should be I can only guess.
Do you want the "00" retained all the way down?
="MJTB" & ROW() & "00" & ROW() entered in B1 returns 23500235
Or simply format to "000" as you progress?
="MJTB"&ROW()&TEXT(ROW(),"000") returns 235235
I would guess the latter.
For second scenario of MJTB2044 same guesses.
Gord Dibben MS Excel MVP
On Mon, 23 Nov 2009 11:26:09 -0800, urlocaljeweler
wrote:
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.
|