issue with formula trimming data incorrectly

[JEAN1972]

I used the formula below to remove the word STEEL HOUSEHOLDWARES EUR1 0895557 to STEEL HOUSEHOLDWARES

but sometimes there are STEEL HOUSEHOLDWARES EUR 1 0895557 it does not remove .


However when there is description with the word eur it removes it completely,

As per attached sample with issues in yellow

Please Login or Register  to view this content.

[KOKOSEK]

Due to double space in these instances before EUR.

Please Login or Register  to view this content.

[Pepe Le Mokko]

Try =IFERROR(TRIM(LEFT(A2,SEARCH(" EUR*",A2)-1)),A2)