Re: Extracting numerals from an alphanumeric string

Giganews Newsgroups
Subject: Re: Extracting numerals from an alphanumeric string
Posted by:  Ron Rosenfeld (ronrosenfeld@nospam.org)
Date: Thu, 10 Jul 2008

On Thu, 10 Jul 2008 12:49:02 +0530, "Srinivasulu Bhattaram"
<bhattara…@gmail.com> wrote:

>I get a statement from my banker as a spread sheet
>
>They look like this
>
>INR18000.00 DR
>
>INR19.37 CR
>
>The numerals indicate the amount, INR indicates currency, Dr indicates Debit
>and Cr indicates Credit
>
>I need a formula which extracts the numerals in the string and put them in
>another cell formatted for Currency
>
>Can any one help?
>
>Is it possible
>
>seena

Entered normally  (NOT as an array formula)

=LOOKUP(9.9E+307,--MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"
0123456789")),ROW(INDIRECT("1:"&LEN(A1)))))
--ron

Replies

None

In response to

Extracting numerals from an alphanumeric string posted by Srinivasulu Bhattaram on Thu, 10 Jul 2008