How to extract data between parentheses in MS Excel

Super handy tip here: how to extract data from between parentheses “( )” in Microsoft Excel. Just create a new column, and in the first cell of that column, enter this formula:

=MID(A1,FIND(“(“,A1)+1,FIND(“)”,A1)-FIND(“(“,A1)-1)

Note: The formula above assumes that your “target” column that has the parentheses is column “A” and the first row 1 has a value with a parentheses in it. If either of these are not the case, just change “A1” everywhere in the formula to match your first target cell that does have parentheses you want to extract from.

And that’s it! Just copy that formula over to the rest of the rows in your new column and you are all set!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s