Find & Replace Text Online

Bulk find and replace across all your text, with optional case sensitivity and regex.

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

Find & Replace

What does this tool do?

This tool finds and replaces text across all your lines at once, with options for case sensitivity and regular expressions. Paste your data, define the replacement, and copy the cleaned result. Runs in your browser.

How to use Find & Replace Text - Free Online Tool

  1. Paste your text, or click "Try with sample data".
  2. Enter the text to find and the text to replace it with.
  3. Optionally enable case sensitivity or regular expressions.
  4. Click Replace and copy or download the result.

Example

Replacing a code across rows:

Before

Text
Status: OPEN
Status: OPEN

After

Text
Status: CLOSED
Status: CLOSED

Every "OPEN" becomes "CLOSED" in one pass.

Excel formula alternative

Prefer a formula? You can achieve a similar result with SUBSTITUTE:

=SUBSTITUTE(A2, "OPEN", "CLOSED")

Excel's SUBSTITUTE replaces text in one cell. This tool does bulk replacement, with optional regex, across everything at once.

When should I use this tool?

Bulk-correcting a repeated value
Standardizing codes or labels
Removing unwanted substrings
Reformatting with regular expressions
Cleaning data before import
Mass-editing exported text

Frequently Asked Questions

Yes. Enable the regex option for advanced pattern matching and replacement.

No. Find and replace runs in your browser.

Yes. Toggle case sensitivity so "Open" and "open" are treated separately when needed.

Yes. Every match across all lines is replaced in one pass.

Related tools

Change Text Case
Trim, Clean & Convert Case
Split Text (Text to Columns)
Find Duplicates
Excel Formula Generator

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 Combine Columns Remove Special Characters Add Prefix / Suffix Reverse Text Convert Text to Numbers Split Full Names Remove Extra Spaces Extract URLs Extract Text Between Characters 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