Hi guys.

Have an interesting challenge.

I am gathering information on pricing from my suppliers into a spreadsheet.
One of my suppliers delivers a pricelist where the values in the column price are like: "4,90€/kg"
In my spreadsheet I need these values, but I need them to be numeric so I can calculate sales prices from them.

I can get them in by using a simple vlookup... but then all text characters need to be removed from the values, preferrably in the same formula, so once its done it will keep working on new input.
Any ideas?