assistance to adjust splitting formula in certain column headers which blank cells

[JEAN1972]

I have a worksheet which split pack size drinks in separate columns packs, per packs, litrage and product litrage headers .


Using formulas works well for splitting but getting issues when pack size description reads with litres , I am getting a blank cells or false in certain cells.

Thanks if any can assist.