=LEFT(A1,FIND(" -",A1)-1)
atau
=Trim(LEFT(A1,FIND("-",A1)-1))-------------------------------------------------------------------------------- ----- Original Message ----- From: ruslianwarazis To: [email protected] Cc: tolong dibaca cara menulis subject... tolong tidak ditulis tolong help atau tanpa subject Sent: Tuesday, March 23, 2010 11:30 AM Subject: ]] XL-mania [[ want take the word before - Ex : BMW - Glass window front left GMC - Glass rear HUMMER - Glass slitting cap I want take the word before - ,How?
