Now, what if there is more than one "/".

Example: ABC1/2x5 1/2
Return 1/2 as .5000

"Max" wrote:

Another take on the post, focusing on the line:
I can "Extract" the 1/2, Now I need the "1/2" converted to .5

Assuming the extracted text string "1/2" is in A1,
try in B1:

=LEFT(A1,SEARCH("/",A1)-1)
/RIGHT(A1,LEN(A1)-SEARCH("/",A1))

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--