1 of 1 people found this helpful
Your formula looks like it will do exactly what you wanted. You just have a couple syntactical errors.
IF LEN([Cell])=8 THEN '1' ELSE RIGHT([Cell],1) END
And if you want to make sure the result is a number and not a string, use this instead:
IF LEN([Cell])=8 THEN 1 ELSE INT(RIGHT([Cell],1)) END
Thanks For your time Christian..
That solved my dilemma.