Hi guys,
I'm having some trouble taking a second string out of a dropbox I have. I'm able to get the first integer but am not able to get the second.
In my drop box I have something like "Deck -- 32 -- 90" - Indicating the temperature in both C and F.
I currently have:
=IF(Q24=0,0,(MID(Q24,MIN(FIND({0,1,2,3,4,5,6,7,8,9},Q24&"0123456789")),FIND(" ",Q24,MIN(FIND({0,1,2,3,4,5,6,7,8,9},Q24&"0123456789"))+1)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},Q24&"0123456789")))))
This code extracts the 32, but I can't seem to manipulate it to get the 90 out! Any help would be greatly appreciated!
Bookmarks