I recently had an OP ask me how to extact the number portion of an imported text string. The text string looks like:
Temperature of starting experiment: 10.25 °C
First I suggested text to Columns but also offered this formula:
=TRIM(MID(A250,(SEARCH(": ",A250)+1),((SEARCH(" °",A250))-(SEARCH(":",A250)))))
anyone have any sugestions of a simpler approach to this formula??