That only works if there are 1 or 2 digits. Why use 2 formulas? Those could
be combined into 1.

Biff

"wmack" wrote in
message ...

you could also add two rows, First row would be:
=SEARCH("x",A1)

Next Row would be
=TRIM(MID(A1,(B1-2),2))

Then just hid the row with the search strind in it.


--
wmack
------------------------------------------------------------------------
wmack's Profile:
http://www.excelforum.com/member.php...o&userid=37801
View this thread: http://www.excelforum.com/showthread...hreadid=573622