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.

1
Find and replace

→ 3 lines

Find

Replace with

Match capital letters exactly

Whole words only

Pattern (regular expression; use $1 for groups)

Your text

3 lines

Result

3 lines

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.

All free tools

Your text stays on this computer
The list editor works on your computer. The text you paste or open is not uploaded or stored by HeyScraper, and closing the page clears it. Saved recipes are kept in this browser only.

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