MS Excel - Extract Values between parenthesis "(XYZ)" Ideal for Coordinates.

[ATD-ZachB]

Use this formula in an excel sheet in order to extract data that is located within an open and closed parenthesis. Ideal for pulling coordinates from data downloaded from the open data portal.

ie "Long text string here (desired info such as X,Y values)"

Formula:
=MID(R2, FIND("(",R2)+1, FIND(")", R2)-FIND("(",R2)-1)

Populate all instances of "R2" with the field that contains the desired data.

To further help separate the latitude longitude use the excel function of "text to columns" (Usually located on the Data ribbon)