Assuming it's always a single digit before and after the "/",
then this would suffice:

With the string in A1, try in B1:

=MID(A1,SEARCH("/",A1)-1,1)
/MID(A1,SEARCH("/",A1)+1,1)

(Hang around for better answers from others <g)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"CADManBill" wrote in message
...
I have a string that is numbers and text that I need to "Extract" the
characters that need, as numbers. Then "CONVERT" them to numbers.

Example string: ABC1/2x5

I can "Extract" the 1/2, Now I need the "1/2" converted to .5