Cutting out required data in unstructured cells

[Nico87]

Hello Everyone,

For an analysis of the sizes of products, I need to cut out the required information. Next to sizes, there is also other information in the ceels such as product name or other digits that I need to get rid of. Problem is, that in each cell there are different obstacles which is why I can't apply the formulas I am familar with.
The sizes are indicated with an "x" inbetween. It stand for length x width or width x length. However, sometimes it's a capital "x" and sometimes there are spaces at the beginning and afterwards.
Also, the sizes don't have the same amount of digits.
Please see the screenshot attached.
Can anyone help, please?

[AlKey]

Hi Nico87 and welcome to the forum
It would be much easier to work with a spreadsheet instead of picture.
Here is a short sample that I manually entered.

Enter formula in H8 and drag formula down

Please Login or Register  to view this content.

v	G	H
7
8	MATTE BLUE SPARKLING 115X200 CM	115x200
9	SAPRKLING MATTE 85 x 150 GREY	85x150
10	MATTE RED MONO
11	MATTE RED MONO 85X300CM	85x300
12	2110- BLACK OPAL WHITE - 85X120	85x120
13	GLASER - 85x150 - HOCHFORMAT	85x150
14	GROS--RAND
15	UNICOLOR 0134/SHAPEMAT-160x160-MIT-RAND	160x160
16	APOTHEKE BERATUNG - 85x150 - HF/OH.GRIP.	85x150

[Nico87]

Thank you so much, AlKey.