Extract Text Between Characters

Get the text between, before, or after a character from every line.

100% private. Everything runs in your browser. Your data never leaves your device.

Extract Text

What does this tool do?

This tool extracts the text between two characters, or before/after a character, from every line at once. Useful for pulling values out of codes, brackets, and delimited fields. Runs in your browser.

How to use Extract Text Between Characters - Free Online Tool

  1. Paste your text, or click "Try with sample data".
  2. Choose a mode: between two characters, before a character, or after a character.
  3. Enter the character(s) or delimiter.
  4. Click Extract and copy the result.

Example

Extracting text inside brackets:

Before

Text
Order (A123) shipped
Order (B456) pending

After

Result
A123
B456

The text between ( and ) is extracted.

Excel formula alternative

Prefer a formula? You can achieve a similar result with MID + FIND:

=MID(A2, FIND("(",A2)+1, FIND(")",A2)-FIND("(",A2)-1)

This Excel formula is fiddly. This tool does before/after/between in one click.

When should I use this tool?

Parsing codes from strings
Extracting values from brackets
Splitting key-value text
Pulling fields from log lines
Cleaning delimited data
Extracting substrings in bulk

Frequently Asked Questions

Yes. Choose before, after, or between modes.

No, it runs in your browser.

That line returns blank so your rows stay aligned.

Yes, you can enter more than one character as the delimiter.

Related tools

Split Text (Text to Columns)
Extract Numbers from Text
Extract Email Addresses
Find & Replace Text
Trim, Clean & Convert Case

Related Tools

Compare Excel Files Excel Formula Generator Merge Excel Workbooks Trim, Clean & Convert Case Remove Duplicates Compare Two Excel Columns Excel ↔ JSON Converter Excel ↔ XML Converter EMI Calculator Age Calculator Excel ↔ CSV Converter Split Excel Sheets Remove Blank Rows/Columns Format Data Income & Expense Tracker Find Duplicates Split Text (Text to Columns) Extract Email Addresses Extract Numbers from Text Word & Character Counter Change Text Case Find & Replace Text Combine Columns Remove Special Characters Add Prefix / Suffix Reverse Text Convert Text to Numbers Split Full Names Remove Extra Spaces Extract URLs Add Serial Numbers Transpose Data Sort Data Delete / Keep Columns CSV Viewer CSV to JSON JSON to CSV CSV to SQL CSV to Markdown Table Markdown Table to CSV Excel / CSV to HTML Table Count Unique Values Data Profiler & Health Check Percentage Calculator Percentage Change Calculator Profit Margin Calculator CAGR Calculator Discount Calculator GST Calculator