=IF(A15 < "",(RIGHT(A15, LEN(A15)-SEARCH("XXX", A15)+1)))

would work if the xxx string exists however would fail for the number
(I assume formated as text

Try as a start

=IF(LEFT(A17,1)="0","XXX"&A17,IF(A17 < "",RIGHT(A17,
LEN(A17)-SEARCH("XXX", A17)+1)))

but if the 00000012345 is a number It will need to be modified to

=IF(isnumber(A17),"XXX"&text(A17,"0000000000"),IF( A17 < "",RIGHT(A17,
LEN(A17)-SEARCH("XXX", A17)+1)))


Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=559376