Hi, does anyone have any idea how to extract/find/retrieve a number from a cell that contains text? The position of the number from cell to cell may change.
THANK YOU for any help!
Example:
(H) 344 mm Hg
* (L) (c) 51 mm Hg
Desired:
344
51
Thanks again!
Last edited by VBA Noob; 01-04-2008 at 06:36 PM.
It depends on the consistency of your data, assuming your number is always followed by a space and then mm try
=TRIM(RIGHT(SUBSTITUTE(LEFT(A1,FIND("mm",A1)-2)," ",REPT(" ",99)),99))
thank you! works perfect
:D
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks