Hey guys, I have this function =LEFT(E2,SEARCH(",",E2)-1) to remove all text after a comma in the E column but when there's no comma the formula throws up a #VALUE! error
Say I had "google nexus 7, brand new" it would show "google nexus 7" however if I had "adidas trainers" it shows "#VALUE!"
Bookmarks