Assuming the text is in cell A1, type =RIGHT(A1,9)

If this doesn't work, the text may contain non-printing characters. If so,
type
=RIGHT(CLEAN(C9),9)

Hope this helps.

--
BernieG


"Mike" wrote:

Hi,
I've a column containing alphanumeric text as 200731705A832565410B12345678.
Out of this text, I need only the 9 right most digits.
How do I go by?
TIA,
Mark