W Wasdell Apr 16, 2009 #1 I am trying to lookup an exact text cell and convert it to a numeric value eg If cell x3 = A15C then the answer will be 15
I am trying to lookup an exact text cell and convert it to a numeric value eg If cell x3 = A15C then the answer will be 15
K klswvu Apr 16, 2009 #3 Microsoft has an excellent article on doing this woth and Array Formula Extracting numbers from alphanumeric strings http://office.microsoft.com/en-us/excel/HA011549011033.aspx
Microsoft has an excellent article on doing this woth and Array Formula Extracting numbers from alphanumeric strings http://office.microsoft.com/en-us/excel/HA011549011033.aspx
