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.

The room code is extracted from between the first opening and closing parentheses.

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.

A missing closing mark gives Check label, while an empty pair returns an empty code.

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

Microsoft’s FIND error and search-position reference