genracela
04-27-2010, 12:35 AM
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:help
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:help