Formula for 1-25 to 26-50

[j2310lime]

Hello,

Is there a formula that will allow me to calculate the cells to show 1-25, 26-50, 51-75, 76-100?

Cell A1 I would input 1-25

I can put in a formula where Cell B1 would show 26-50, then 51-75 ...


Thank you~!

[Pete_UK]

You can use this formula in B1:

=LEFT(A1,FIND("-",A1)-1)+25 & "-" & RIGHT(A1,LEN(A1)-FIND("-",A1))+25

then copy it across as far as you need to.

Hope this helps.

Pete

[protonLeah]

also:

Please Login or Register  to view this content.

[j2310lime]

You guys are geniuses thanks!!

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.