I've been trying to get this multiple if statement to work, but I can't seem to get it right. I have a large list of cells with procedures that have the laterality indicated at the end: i.e:
LASIK SURGERY OD
LASIK SURGERY OS
LASIK SURGERY OU
I'm trying to strip the OD,OS,OU with a long nested IF that uses ISERR,LEFT,and FIND but no such luck.
Bookmarks