“Extract order quantity”
Use this formula in Excel to extract the order quantity from a cell. Replace target_cell with the cell reference you want to read from (for example, A2):
=VALUE(RIGHT(target_cell,1))Watch the video above for a step-by-step walkthrough.