If it is always formatted like that, you can use the LEFT function to
look at the first 3 characters in the cell. But what exactly do you
need to do with it?

You said you want to pick the currency. Is that just to show it in
another cell? Are you try to add up all the EUR? Is the currency the
lookup_value in your Vlookup function to then look up something
elsewhere?