Counting up with numbers and text
 

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

Counting up with numbers and text
 

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


--
Regards,

Peo Sjoblom



"pwalters" wrote in message
...
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

Counting up with numbers and text
 

In B1 enter =A1 & ROW(A1)

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


Gord Dibben MS Excel MVP

On Tue, 19 Jun 2007 09:07:39 -0700, pwalters wrote:

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

Counting up with numbers and text
 

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





"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
In B1 enter =A1 & ROW(A1)

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


Gord Dibben MS Excel MVP

On Tue, 19 Jun 2007 09:07:39 -0700, pwalters
wrote:

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

Counting up with numbers and text
 

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

On Tue, 19 Jun 2007 10:58:50 -0700, "Peo Sjoblom" wrote:

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

Counting up with numbers and text
 

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


--
Regards,

Peo Sjoblom



"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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

On Tue, 19 Jun 2007 10:58:50 -0700, "Peo Sjoblom"
wrote:

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

Counting up with numbers and text
 

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



"Peo Sjoblom" wrote:

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


--
Regards,

Peo Sjoblom



"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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

On Tue, 19 Jun 2007 10:58:50 -0700, "Peo Sjoblom"
wrote:

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

Counting up with numbers and text
 

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

"christine b" wrote:

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



"Peo Sjoblom" wrote:

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


--
Regards,

Peo Sjoblom



"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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

On Tue, 19 Jun 2007 10:58:50 -0700, "Peo Sjoblom"
wrote:

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