Find and replace any phrase in a block of text
Replace any word, phrase, or regex pattern in any block of text.
Interactive Sample Data
| id | text |
|---|---|
| 1 | Status: pending — Order #1001 |
| 2 | Status: PENDING — Order #1002 |
| 3 | Status: complete — Order #1003 |
How this tool works
Things that usually go wrong
- Regex special characters (., *, +, ?, (, ), [, ], {, }) in a literal search term will cause unexpected matches — use 'literal' mode or escape them with backslash.
- Capture group references ($1, $2) in the replacement only work when 'use regex' is specified.
- Replace with a newline character: write '\n' in the replacement and specify 'interpret escape sequences' in the instruction.
Edge cases we tested
Text returned unchanged with a note: '0 replacements made.'
All occurrences of the search term are deleted. Instruction: replace 'unwanted' with nothing.
Capture group $1 expanded correctly in the replacement.
In literal mode, the dot is escaped automatically before being used as a pattern.
Default is all occurrences; add 'first occurrence only' to limit to one.
Frequently Asked Questions
Can I do multiple different replacements in one run?
Yes — list them as separate instructions on different lines, e.g. 'Replace foo with bar' then 'Replace baz with qux'. The engine applies them in sequence.
Does this work on CSV data?
Yes, but it replaces text inside quoted cells the same as text outside them. For column-specific replacement, use 'Find and Replace in CSV'.
Can I replace a newline character?
Yes — use 'use regex' mode and write \n in the search pattern.
What is the maximum text size?
The engine runs inside your browser and handles several megabytes of text without issue.
Related tools
Find and Replace in CSV
Replace text values across all cells or within specific columns in a CSV file.
Open Tool →Regex Replace in CSV
Apply regex patterns with capture groups to transform cell values across CSV columns.
Open Tool →Remove Extra Spaces
Collapse multiple consecutive spaces into one and strip leading/trailing spaces from any text.
Open Tool →Remove Special Characters
Strip invisible control characters, non-ASCII symbols, smart quotes, and unwanted punctuation from spreadsheet cells.
Open Tool →