Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |