You have labels such as Hall (N12) and West studio (W204). Extract the codes into their own column so you can match them to a room list.
Find the first pair and return the text inside
Put the labels in A2 and A3. In B2 enter:
=IFERROR(MID(A2,FIND("(",A2)+1,FIND(")",A2,FIND("(",A2)+1)-FIND("(",A2)-1),"Check label")The second search starts after the opening mark. Fill down and check N12 and W204.

Illustrated extraction. The source name can be short or long.
Try a missing closing mark and an empty pair
Studio (B18 should show Check label. Studio () should return an empty code. Review both if the code is required. For nested marks or a label with a note in an earlier pair, establish which pair contains the code before using this formula across the file.

Illustrated exception check. Review both if every room needs a code.



