separating or extracting numbers between two strings into two columns

[paradise2sr]

Dear Sir,

As enclosed in my workbook,I want to separate the numbers between two strings of which one is in the left hand side and other is in mid.The data is in Column D.The simple way to understand is that,

Total Amount = Amount X Exchange Rate

Total Amount is in Column B, where as "Amount X Exchange Rate" is in combined form in column D.Yes, this I want to separate i.e Amount separately column and Exchange Rate in separate column.I have shown one expected result in column E,F.There are certain characters like ],= which you have to not to take any amount after ] or =.The currency is somewhere,$/$$/INR/IRS,etc.

If u require any further info then do let me know.

Hope this is suffice.

With Best Rgds

[hemesh]

Hello Find attached ! formula used here is array formula !

I have mentioned certain value which is less than 0 means -53 or -900 in column G they are appearing because value in column B is higher
than results after multiplying

[paradise2sr]

Thanx,

As always,you are really genius man.

With Best Rgds,

[hemesh]

Thanks for the comment !
but I am no way genius just learning and know a little bit.

[paradise2sr]

Since I am looking accounts here ,I am facing a variety of problems with large data regarding extraction/compilation,etc.In these condition, this forum and you and other forum contributors has really made my work very easy and letting me to learn something wherever I felt problems.

Hoping you and other forum contributors a continuous co-operation and support.

With Best Rgds,