On Sun, 7 Nov 2004 14:37:39 -0800, "Biff" wrote:

Hi!

I see you've got several replies but here's another option.

If your codes are always the same length:

999-000-00089101 = 16
232-987-00123456 = 16

AND, if the portion of the code you need to extract NEVER
starts with 0:

=IF(--MID(A1,11,1)=0,RIGHT(A1,5),RIGHT(A1,6))

Returns:

999-000-00089101 = 89101
232-987-00123456 = 123456

Biff


=--right(A1,6) would be simpler, and give the same result.


--ron