#ERROR using SUBSTITUTE()

[Nocode34130]

Hi !

I'd like to substitute the "€" symbol only when it's alone in a field. (alone but with a space in front)

For example, I've sometine a field with :

1.00 €

2.00 €

€

€

€

and it's very ugly in our contract.  ><

I thought at the "LEN" and "FIND" formulas but I struggle to not replace the € when it is accompanied with a number... 

It would require a formula that only searches and replaces € symbols when it is alone with a leading space.

Any ideas will be greatly appreciated :-)))) 

Thanks !