SMALL HELP WITH SERIES

[Stephen]

Thank you for looking at this post, here's what I need
help with:

I am trying to create a worksheet that auto-updates a
series that is somewhat non numerical but not in adjacent
cells.

For example, lets say you entered in cell A1

2-15

and if you dragged the black cross either horizontally or
vertically, it would advance the series (2-16, 2-17...
and so on, although it is not a true number.)

Now, if I wanted to do this in cell A20 only, I can not
simply do "=A1+1", because its not numerical.

Is there a way to advance the series like that? I know
there must be some sort of syntax but HELP is very
ambiguous about this.

Your help will be greatly appreciated.

-Stephen

 

[Thomas]

Try
=LEFT(A1,2)& MID(A1,FIND("-",A1)+1,15)+1

this assumes your first digit before the - will also be less then 10

 

[Thomas]

If the numbers before the "-" will vary use:
=LEFT(A1,FIND("-",A1))&MID(A1,FIND("-",A1)+1,15)+1