I have a datasheet of 12000 description looking a formula to delete in columns B all description having the wording EUR1122333 with its numbers.
Some have brackets and other not .
Thanks if anyone can assist
I have a datasheet of 12000 description looking a formula to delete in columns B all description having the wording EUR1122333 with its numbers.
Some have brackets and other not .
Thanks if anyone can assist
This should do:
=IFERROR(TRIM(LEFT(B2,SEARCH("EUR",B2)-1)),B2)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks