split string into multiple cells

Hello,
Can someone help me with the proper filter to split a string into multiple cellse?

Here's a example of what I'm looking for;

A1: name (AAA) xxxxxx xx xx xx-xxx-xxxxxxxxxxxx (xxx xxx. bbbbbbbb 111 xbxbxb)

split to the following cells

B1: name (AAA)
C1: bbbbbbbb 111
D1: xbxbxb

the length of the words always change, so text-to-columns will not work as I have over 1500 cells to split up.

Thanks,

Hi,

I'm not sure if I understand well. Are we thinking the same?

Please Login or Register  to view this content.

This works!!

Thank you