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 دنبال می‌کنید

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

صفحه بندی