Hi.
I would like to come up with a formula that extracts cost (numbers) from a string, before simbol "euro", but with the difficulty that there are other numbers in the same string, and numbers can have different forms as seen in the attached example file. I use a formula but it doesn't work for every case. I think it has to be validating string extraction from simbol "euro" adding 1 character at a time and see if it's a number, do this for for previous characters until it says it's not a number any more because it may have a space, or "(" or any other simbol and not number or comma or dot to separate decimals. Hope it's clear in the example. Thanks in advance.
Bookmarks