Alphanumeric +1

[dgeorge]

Hello,

I need help with a formula to add 1 to an alphanumeric cell. Cell A1 uses the formula: =RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1))) to make A1 the same as the worksheet name. I want a formula for L1 to be A1 + 1. I have 16 weeks of golf league and each week is a different worksheet. I also have next week's teams listed on this worksheet. If A1 is WK1, I want L1 to be WK2. The spreadsheet for week 2 will have A1 as WK2 and L1 as WK3, and so on.

Please help!

Thanks!

 

[Ken Cowen]

The best way to deal with stuff like this is often to create a custom format for you cells. If you format with a custom number format:

WK #

you may be able to simplify things siginifcantly.

I hope this helps.

Ken

 

[dgeorge]

Thanks Ken, I'll give that a try and see what happens.