Cell Counting? Is that what you call it?

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

Douglas J. Steele

Sounds as though you're talking about Excel.

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 counting numbers 3
Word macro that can call cells out of Excel for a find and replace 0
Return a cell address 4
Need help with "Function to do what auto-filter does" 3
Goal Seek with variable Set Cell 1
Count Number of Unique Cells That Don't Have Certain Characters 0
Create if partial match then copy and paste data from one cell to another 1
Multi-demensional frequency distribution 4

Top