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 !
