Hi Guys,
This is what my text looks like.
Example (2) PTY LTD (VIC)
Example (2) PTY LTD-STHN (VIC)
Example (2) PTY LTD-NTHN (QLD)
Example (2) PTY LTD-CNTRL (NSW)
I want to show data which is in front of second set of brackets - Example (2) PTY LTD
I am using formula...