PDA

View Full Version : Solved: Help on alpha numeric subraction...



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

Bob Phillips
04-27-2010, 01:15 AM
Try

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

genracela
04-27-2010, 04:40 PM
Thanks XLD!