Spliting text

[Deepak Reddy]

Helo,

I have nearly 22,000 links on an excel sheet with different type of repeated characters in the text, so i want to split up the last CAS number in the brackets and separate them in an another column, i have tried it in text to column but due to repeated characters it is not happening for me. kindly help me with this issue, i would provide an example of texts here

Collagens, hydrolyzates, N-[3-(dodecyldimethylammonio)-2-hydroxypropyl], chlorides (CAS Number 132538-89-7)

Starch, dihydrogen phosphate, 2-(diethylamino)ethyl ether, sodium salt, hydrochloride (CAS Number 143734-28-5)

Fatty acids, soya, esters with polypropylene glycol ether with sorbitol (6:1) (CAS Number 127947-24-4)


So i have 22,000 links as such and i want only the ( CAS Number XXX-XX-X) in a seperate column, i would highly appreciate if somebody can help me ASAP. Thank you.