The first data set I worked with had the FREIGHTLINER - TRUCKS - MEDIUM / HEAVY DUTY so I used:
IIf([Make] Like "* - *",Left([Make],InStr([Make]," - ")-1),[Make])
That worked fine. My boss asked me to see if it would work on another data set. That data set has the HINO (MEDIUM DUTY). I do not...