Thread: How do I extract numbers from a cell with both text and numbers?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Domenic
 
Posts: n/a
Default How do I extract numbers from a cell with both text and numbers?
Try...

=MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"01234 56789")),1024)+0

Hope this helps!

In article ,
"SHANNON" wrote:

Examples:
AA100.10
ANN242.21
Reply With QuoteReply With Quote