|Subject:||Re: Extracting numerals from an alphanumeric string|
|Posted by:||Ron Rosenfeld (firstname.lastname@example.org)|
|Date:||Thu, 10 Jul 2008|
On Thu, 10 Jul 2008 12:49:02 +0530, "Srinivasulu Bhattaram"
>I get a statement from my banker as a spread sheet
>They look like this
>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
I just split the formula in a different place, to make sure that inadvertent
word-wrap issues don't arise when you paste it in.
Extracting numerals from an alphanumeric string posted by Srinivasulu Bhattaram on Thu, 10 Jul 2008