tblA has commodities such as ME Milled Rice, and tblB has just ME and second field with load factor
=Mid(tblA.Commodity, 1, InStr(1, " ", tblA.Commodity) - 1) = tblB.Commodity
<tbody>
tblA
field1
field2
Commodity
abc
123
MR - Milled Rice
tblB
Commodity
LF
MR
22
</tbody>