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
 

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

Incrementing values 2
How to map cells to a reference then copy adjacent ones 4
If I have a list of numbers, how do I insert a dash in each one? 2
How do i set up a data base in excel for code 128 1
how do i put increments in the row or column numbers? 3
How do I change sizes in adjacent cells? 1
conditionally format pairs of cells in columns 1
how do i add in numbers automatically based on adjacent cells cont 2

Top