about excel

Using VBA, I need help guys on how to write a VB code that will read the contents of a cell and identify delimeters or special characters, for example:

say this line is in A1: “Ben (NJ), Anton(FL)”

I want to put Ben and Anton in one column under name and NJ and FL into another column under state and omit the ( and ). I’m planning to store the result in a different worksheet.

I appreciate it guys.