Solved: Help on alpha numeric subraction...

[genracela]

I have a data in column S8

ASFCN10 and in S7 it should return ASFCN09

and I tried this formula

=LEFT(S7,LEN(S7)-0-1)&RIGHT(S7,1)+0-1

The problem is it returns ASFCN1-1 instead of ASFCN09...

Please help

[Bob Phillips]

Try

=LEFT(S7,LEN(S7)-2)&TEXT(RIGHT(S7,2)-1,"00")

[genracela]

Thanks XLD!