Extract Text from String in Excel

ساخت وبلاگ

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))

- - , .

Recent Questions...
ما را در سایت Recent Questions دنبال می کنید

برچسب : نویسنده : استخدام کار superuser بازدید : 330 تاريخ : جمعه 30 بهمن 1394 ساعت: 23:44