Extracting numerals from an alphanumeric string

Giganews Newsgroups
Subject: Extracting numerals from an alphanumeric string
Posted by:  Srinivasulu Bhattaram (bhattara…@gmail.com)
Date: Thu, 10 Jul 2008

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