Excel Find and Replace Online – Per Column, Regex, Ctrl+H Alternative

2026-08-17

  • Excel
  • find and replace
  • Ctrl+H
  • regex
  • column replace
  • CSV
  • WPS
  • tutorial

What “Excel find and replace” means

Find and replace in Excel means changing one piece of text to another across a sheet—old company name to new, Pending to Unpaid. On the desktop that is Ctrl+H. WPS has the same dialog. For bulk jobs, different rules per column, or when Excel is not installed, use ComTools Excel Find and Replace.

Typical long-tail needs:

  • Replace in one column only
  • Different find/replace per column
  • Regex replace and match case
  • All worksheets at once
  • CSV / WPS exports without opening Excel

Desktop Excel / WPS: Ctrl+H

  1. Open the workbook and select a column or range.
  2. Press Ctrl+H (Find and Replace).
  3. Enter Find and Replace with.
  4. Optional: match case, match entire cell; wildcards for patterns.
  5. Click Replace All. Repeat per sheet, or group sheets (easy to over-replace).

Limit: you usually get one find/replace pair at a time. Renaming a brand in column A and a status code in column B means two passes, with little preview of how many cells changed.

Online: per-column rules (better for bulk)

Open Excel Find and Replace (free, no signup):

  1. Upload .xlsx or .csv.
  2. First rule can be “all columns” or one column.
  3. Click Add rule: e.g. column A to be good → all good, column B abc → bb.
  4. The column dropdown is searchable when headers are long.
  5. Optional: regex, match case, all worksheets.
  6. Preview highlighted hits and counts, then export. Your original file stays on disk.

Uploads are processed in memory and discarded after the response. Do not upload sensitive spreadsheets. More Q&A: /excel-find-replace/faq.

When to use regex

Goal Tip
Plain rename / status text Regex off, literal find
Strip a prefix like SKU- Regex on, match the pattern
Messy spaces Clean first with Data cleaner

If the hit count looks wrong, turn regex off and preview again.

Ctrl+H vs the online tool

Need Desktop Ctrl+H Online find/replace
One column only Select that column first Pick the column in the rule
Different replace per column Multiple passes Multiple rules in one run
Preview before changing Find Next Highlighted hits + counts
All sheets Easy to miss or overdo Optional whole workbook
No Excel / CSV only Awkward Browser upload
Formulas Watch the selection Still back up before export

Find/replace vs trim, dedup, split

Goal Use
Change A to B (wording) Find and replace
Trim spaces / change case Case and trim or Data cleaner
Remove duplicate rows Remove duplicates
Split one column Split column
Join two columns Merge columns

Suggested workflow

Export CSV / xlsx
  → Find and replace to unify wording (this guide)
  → Optional dedup / blank-row cleanup
  → Excel to SQL or share the file