Help with a formula to extract text clips out of strings. Tuing SP BILL(DL/ON-SITE CONT) into DL/ON CONT and ST MISC(TRAVEL) into TRAVEL. Can this be done?
I'm having trouble removing "-SITE" from one cell without ruining the other. Here's what I have so far... =MID(A1,FIND("(",A1)+1,FIND(")",A1,FIND("(",A1)+1)-1-FIND("(",A1))
- - , .
برچسب:
نویسنده: استخدام کار