Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting a mixed text/number column based on text in another colum | Excel Discussion (Misc queries) | |||
Counting Occurrence of Text within Text in Cells in Range. | Excel Worksheet Functions | |||
Counting rows containing data (both numbers and text) | Excel Worksheet Functions | |||
Counting NUMBERS &/or TEXT from a column to other sheet ? | Excel Worksheet Functions | |||
Counting Numbers with Text | Excel Worksheet Functions |