Cell Counting? Is that what you call it?

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.

Sounds as though you are talking about Excel.

Sounds as though you are talking about Excel.

This newsgroup is for questions about Access, the database product that is
part of Office Professional.

You'd be best off reposting to a newsgroup related to Excel.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)