Thread: using mid find to either extract a number with 2 decimals or excludeFROM A STRING
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld[_2_] Ron Rosenfeld[_2_] is offline
external usenet poster
  
Posts: 1,045
Default using mid find to either extract a number with 2 decimals or exclude FROM A STRING
On Tue, 19 Feb 2013 14:02:36 -0500, Ron Rosenfeld wrote:

Amount
=TRIM(RIGHT(SUBSTITUTE(A2," ",REPT(" ",99)),99))

And to make that a numeric value and not a text value, precede with a double unary

=--TRIM(RIGHT(SUBSTITUTE(A2," ",REPT(" ",99)),99))
Reply With QuoteReply With Quote