View Single Post
  #3   Report Post  
inequitude inequitude is offline
Junior Member
 
Posts: 2
Default

Quote:
Originally Posted by wickedchew View Post
=(MID(A1,FIND("-",A1)+1,FIND("x",A1)-FIND("-",A1)-1))*(MID(A1,FIND("x",A1)+1,FIND(",,",A1)-FIND("x",A1)-1))
Champion mate- worked a treat.
For future reference, if possible, could you explain above?