TextBoth2026-07-15

How to Extract Text Between Parentheses, Commas, or Any Characters

Extract Text Between Parentheses

Excel: =MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1)

Google Sheets (simpler with regex): =REGEXEXTRACT(A1,"\((.+)\)")

Extract Text Between Commas

For the Nth value in a comma-separated list, combine TRIM, MID, and SUBSTITUTE with REPT.

Key Difference: REGEXEXTRACT

Google Sheets has native REGEXEXTRACT which makes complex text extraction trivial. Excel requires nested MID/FIND combinations or VBA. This is one of the biggest formula compatibility gaps between platforms.

Need a custom formula?

Describe what you need in plain English and get the exact formula instantly.

Try the Generator →