Thread: how to extract numbers from imported cell with text and numbers?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jyin jyin is offline
external usenet poster
  
Posts: 2
Default how to extract numbers from imported cell with text and numbers?
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
Reply With QuoteReply With Quote