Separate numbers from address

[Klitos]

Hi,

I have an anddress with numbers. Sometimes has only address number and sometimes the appartment also.
I want to separate those numbers in two different columns.
Like the attachment.

Thanks
K.

SAMPLE.xlsx

[zbor]

Try this...

Only problem if first number is also last number

[Klitos]

Thanks was very helpfull..!


Thanks
K.