Take certain parts of string

[windzz]

Hello. I know this should be easy for a professional VBA writer.
Could anyone please help me with this?

I have a text string:

2200x180x12

And I need to take numbers from string (numbers always separated by "x")

dim1=2200
dim2=180
dim3=12

Maybe someone has a similar vba code for this?

[nigelog]

if all dimensions in column A - result columns B to D

Please Login or Register  to view this content.

[maras_mak]

Data are in column A from A1.

Please Login or Register  to view this content.

[windzz]

Thank you! Worked like a charm!

[nigelog]

Glad to help. Can you please mark as solved