Free tool
Find and replace text
Find and replace text in every line of your list at once. Match whole words only, match capital letters exactly, or use a pattern (regular expression).
The example is loaded. Paste your own list to replace it.
→ 3 lines
Find
Replace with
Match capital letters exactly
Whole words only
Pattern (regular expression; use $1 for groups)
Your text
Result
What it does
Replace text in every line. Type \n in "Replace with" to start a new line.
Settings you can change
- Find
- Replace with
- Match capital letters exactly
- Whole words only
- Pattern (regular expression; use $1 for groups)
When to use it
A list of prices says "USD 20". Replace "USD " with "$" so a spreadsheet reads them as money.
Example: find and replace text
Settings used: Find: USD ; Replace with: $.
Input
Result
Tips
- Type \n in "Replace with" to start a new line, for example to split at every comma.
- With "Pattern" on, $1 and $2 put back the parts in brackets: (\w+) (\w+) → $2, $1 turns "Jane Doe" into "Doe, Jane".
Often used with
Delete digits, letters, emoji or any characters you list.
Keep only the parts of each line that match a pattern (regular expression).
Filter lines by a word or pattern.
Your text stays on this computer
Got your list from a web page?
HeyScraper turns the page you’re on into a spreadsheet, so you can skip the copying and pasting. Free: 500 pages a month.
Get HeyScraper