Counting up with numbers and text

P

pwalters

Hi i am trying to count up +1 to each cell which is easy enough but i have
added text to the original cell and it has stopped working. for example cell
1 has LN1000 my formulae at the moment reads (A1+1) i want the answer to be
LN1001 is it possible? I am a novice at excel so i reckon its dead essy for
an expert. Thanks in advance. Phil
 
P

Peo Sjoblom

If you just want to increase LN1000 with one for each cell just copy it
down, if you need a formula use

=LEFT(A1,2)&RIGHT(A1,4)+1

and copy down
 
G

Gord Dibben

In B1 enter =A1 & ROW(A1)

Drag/copy down or double-click on B1 fill handle.


Gord Dibben MS Excel MVP
 
P

Peo Sjoblom

Will not work, it will change from

LN1000

to

LN10001


not to

LN1001

then in the third row it will return

LN100012

in the fourth

LN1000123

and so on


--
Regards,

Peo Sjoblom
 
G

Gord Dibben

Thanks Peo

Poor quality control in the testing dept. Some heads will roll<g>

Maybe OP could just enter LN1000 in a cell then drag/copy down the column
returning

LN1001
LN1002
Ln1003

and onwards.


Gord
 
P

Peo Sjoblom

That's what I suggested as well since it seems that he just wants to change
it that way
 
C

christine b

Agree with Gord, or you could go fancy with Edit|Fill|Series...
But if you really must use a formula, go with the original suggestion from
Peo, but make sure to not put the formula in A1 !!! Drag the fill handle
down as far as you like.


A1 type your value of LN1000
A2 =LEFT(A1,2)&RIGHT(A1,4)+1


Christine
 
P

pwalters

Thanks everyone for your time and effort, i have inputted the formula as the
number to be changed appears in different places on a spread sheet and not in
a row or column. i changed the A1 to whatever the cell was and it works just
fine.
how does it do it by the way then in future i can try it with other things.

once again thanks very very much
Phil
 
Top