I suggest that the labels in A1:F1 should be Qty, QtyforPrice, SaleQty, Price, UnitPrice, and TotalSale, respectively.
In C2, the formula is:
=IF(B2=“”,
A2,
—LEFT(B2,FIND(“ for $“,B2)-1))
In E2, the formula is:
=IF(B2=“”,
D2,
—RIGHT(B2,LEN(B2)-FIND(“ for $”,B2)-5))
In F2, the formula is:
=C2*E2