Hello,

I have the following two questions regarding excel:

Question 1

I have a collumn with over 3000 cells containing amounts in different ccurrencies, only problem is that the cells are formatted as text instead of currency and that lay-out is different for all cells. So for example I have the following cells (the cell contains the text between brackets):

"USD 31,000"
"CHF 24.000 "
"DEM 1,000 "

So the cells contain emtpy spaces, commas, points, letters and numbers. Because I am using the cells in other formulas I want them all to be similar and I only need the numbers. How can I extract only the numbers from these cells? So I get in the previous example:

"31,000"
"24,000"
"1,000"

Question 2:

I also have a collumn which contains 3000+ cells looking like this (between brackets):

"EUR 34,148 -USD 32,000- GBP 21,334 "
"EUR 16,007 - USD 15,000 - GBP 10,000"
"EUR 18,675 - USD 17,500 - GBP 11,667 "
etc.

Now, for this column I am only interested in the EURO value, but again, I want them in the same format as question 1 (beware: again the layout is not the same for all cells, so some contain additional spaces). So how can I convert the above to:

"34,148"
"16,007"
"18,675"

Thank you for your time and help!