Hello everyone.



I'm currently working with order sheets for flavoring company.
When customer want to order flavor he need to put number (1,2,3,4,5 etc.) that means quantity of kg, and letter (like Q, K, C etc) that means which packaging of this kg.
After customer fill up order sheet - putting everywhere number and letter - I can't anymore calculate in Excel what is the total order, and I need to calculate in by calculator.
Order sheet consist of 5 columns:
- name of flavor
- and 4 columns to the right to put number and letter there for the order

It is important number and letter stay at same cell for production.

Can someone advice me better solution how to calculate
- maybe formula that will count only number and disregard letters.
- or formula where I can add letter to entire table where I have number after I get total for each column.

Hope I explained it well and really hope someone can help me.

Thank you a lot everyone.