Thread: extracting numerics from literal strings
View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.programming
Harlan Grove Harlan Grove is offline
external usenet poster
  
Posts: 66
Default extracting numerics from literal strings
"Harlan Grove" wrote...
....
and to pull the last numeral substring,

=RegExpSubstitute(A3,"^.*(\d+)\D*$","$1")
....

Mucked that up. Make that

=RegExpSubstitute(A3,"^.*?(\d+)\D*$","$1")


Reply With QuoteReply With Quote