Find and substitute the single € symbols

Topic Labels: Base design Formulas
425 0
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

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 !

0 Replies 0