Thread: Extract numeric part of alphanumeric cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sarah (OGI) Sarah (OGI) is offline
external usenet poster
  
Posts: 128
Default Extract numeric part of alphanumeric cell
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