excel question -

magic roundabou

afternoon all
a question with regard to excel i have a list of numbers 11-1000 and the 1000 gos up by one ie 11-1001 - 11-1002 etc - is there any way i can increase the numbers in a list - ie if it was just 1000 i would put in the next cell A1+1 and it would be 1001 - but because of the 11-10001 it is coming up #Value
As always thanks in advance
clare

carveone

You'll probably have to use a few string operations to chop the string up and then glue it back together. This assumes you want to keep the format as a string...

carveone

Try this for starters:

=VALUE(MID(A1, FIND("-", A1, 1) + 1, 10))

You can add one to that and convert it back to a string. I hope

homer911

Just use a custom number format

##-####

magic roundabou

magic roundabou wrote: »

afternoon all
a question with regard to excel i have a list of numbers 11-1000 and the 1000 gos up by one ie 11-1001 - 11-1002 etc - is there any way i can increase the numbers in a list - ie if it was just 1000 i would put in the next cell A1+1 and it would be 1001 - but because of the 11-10001 it is coming up #Value
As always thanks in advance
clare

excel recognises that with a click and drag
throw in 11-1000 and 11-1001 and highlight both, and drag as far as you want it to increase...
if you want +2 then stick it in 11-1000 and 11-1002

carveone

homer911 wrote: »

Just use a custom number format

##-####

DOH!

Thanks homer911.

magic roundabou

thanks for the help - got it working with those solutions