G
Guest
does anyone know how to extract the number from an imported cell if the cell
contains both text and numbers?
eg. the cell contains "USD 30.79 (March 27, 2007)" but i want to use only
30.79 in a formula in another cell
contains both text and numbers?
eg. the cell contains "USD 30.79 (March 27, 2007)" but i want to use only
30.79 in a formula in another cell