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

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

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
--

Thank a bunc, that works and save me another headache!

"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
--

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
--

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

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

Assume you're referring to the 2nd instance of "1/2"
located after the space in the string

If A1 contains: ABC1/2x5 1/2

Try in B1:

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

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