Re: Extracting numerals from an alphanumeric string

Giganews Newsgroups
Subject: Re: Extracting numerals from an alphanumeric string
Posted by:  Rick Rothstein \(MVP - VB\) (rick.newsNO.SP…@NO.SPAMverizon.net)
Date: Thu, 10 Jul 2008

Is the text in front of the number always a 3-character abbreviation
followed by a space? If so...

=MID(A1,4,LEN(A1)-6)

Rick

"Srinivasulu Bhattaram" <bhattara…@gmail.com> wrote in message
news:eZv$80l4IHA.9…@TK2MSFTNGP04.phx.gbl...
>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

Replies

In response to

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