Instead of RIGHT(some_cell,1), use this variation:
--RIGHT(some_cell,1)

(that's 2 minus signs in front)

Does that hellp?

Ron