| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add one
Hi,
This is probably really really easy (I hope)... I have a column which starts like this: P1001 P1002 P1003 P1004 But then gets messed up with a load of other different formats of numbers. I need a formula so that the next cells automatically shows P1005, P1006 etc. Is this possible? Thanks in advance. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Add one
="P"&1000+ROW()
in row1 returns P1001 in row2 returns P1002 etc. Regards, Stefi -- Regards! Stefi €˛GillianX€¯ ezt Ć*rta: Hi, This is probably really really easy (I hope)... I have a column which starts like this: P1001 P1002 P1003 P1004 But then gets messed up with a load of other different formats of numbers. I need a formula so that the next cells automatically shows P1005, P1006 etc. Is this possible? Thanks in advance. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Add one
Hi,
I may be missing something here but why not just select the cell with P1004 in and drag down? Mike "GillianX" wrote: Hi, This is probably really really easy (I hope)... I have a column which starts like this: P1001 P1002 P1003 P1004 But then gets messed up with a load of other different formats of numbers. I need a formula so that the next cells automatically shows P1005, P1006 etc. Is this possible? Thanks in advance. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Add one
Oh my goodness, I can't believe it was that simple - worked perfectly, thanks
so much!!!! "Mike H" wrote: Hi, I may be missing something here but why not just select the cell with P1004 in and drag down? Mike "GillianX" wrote: Hi, This is probably really really easy (I hope)... I have a column which starts like this: P1001 P1002 P1003 P1004 But then gets messed up with a load of other different formats of numbers. I need a formula so that the next cells automatically shows P1005, P1006 etc. Is this possible? Thanks in advance. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Add one
Glad I could help.
"GillianX" wrote: Oh my goodness, I can't believe it was that simple - worked perfectly, thanks so much!!!! "Mike H" wrote: Hi, I may be missing something here but why not just select the cell with P1004 in and drag down? Mike "GillianX" wrote: Hi, This is probably really really easy (I hope)... I have a column which starts like this: P1001 P1002 P1003 P1004 But then gets messed up with a load of other different formats of numbers. I need a formula so that the next cells automatically shows P1005, P1006 etc. Is this possible? Thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
