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
the length of the words always change, so text-to-columns will not work as I have over 1500 cells to split up.