=trim(left(reference,find("-",reference)-1))

blessings,
tomz
  ----- 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 1:30 PM
  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?



  

Kirim email ke