Thread: Extract numeric part of alphanumeric cell
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
external usenet poster
  
Posts: 4,339
Default Extract numeric part of alphanumeric cell
=LOOKUP(10^10,--MID(A1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"01234567 89")),ROW(INDIRECT("1:255"))))

Data in A1

"Sarah (OGI)" wrote:

Cell AR12 has a value that reads 'Visit 6 GWP'.
In an adjacent cell, I would like to extract the numeric value of this text
string.
Any ideas re how I can do this through the use of a formula?
Reply With QuoteReply With Quote