How do I fill adjacent cells with incrementing numbers

G

Gilbert

I want to fill in adjacent cells whether downwards, upwards, or sideways with
numbers that increment by one.

for example: P5-10-A200-00

I want to increment by 1, for each adjacent cell without having to type in
the whole sets of numbers.
i. e. P5-10-A200-00, P5-10-A201-00, P5-10-A202-00 and so on and so forth.
Is there a way to do this? Currently I find that excel increment only the
last digit.
 
M

Mike H

Hi,

One way for you to consider is to enter your first number like this

="P5-10-" &ROW(A200)&"-00"

And drag down.

Mike
 
G

Gilbert

Dear Mike,

Thanks for the reply. Is there any other way? The reason is when I did
what your advise, it shows only P0081-51-285-00
when i type below in excel. The A is missing.

="P0081-51-"&ROW(A285)&"-00"

Gilbert
 
D

David Biddulph

The A is missing because it wasn't included in the text string in your
formula. Look again at your formula, and what it is asking for. Modify the
formula appropriately.
 

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

Top