2 Handy MS Excel Data Manipulation Tips – Extract & Remove Text in Parentheses

To Extract text from parentheses, use this formula in a new column, assuming the target column is column “A”:

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

Note: Change “A1” accordingly to match the column and specific cell that you are targeting, then copy that formula to all other cells in your new column. Done!

And then to remove the text and the parentheses from all values in a column:

  1. Select the entire column
  2. Do a Find and Replace
  3. In the “Find what” box, enter this: (*)
  4. Click “Replace All”. Done!

 

Advertisements

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