Find and replace in Excel
Upload your file, say what to look for and what to replace it with, and download the result. Without opening Excel.
When to use it
When the same change has to happen across hundreds of rows: unifying "Ltd." and "Ltd", fixing a misspelled supplier name, stripping a prefix from every code, or normalising "Yes"/"YES"/"yes" into a single value.
Partial match or entire cell
This is the option that changes the outcome the most. With partial match (the default), searching for "Ana" also changes "Ana María" and "Mariana". With entire cell, it only changes cells whose whole content is exactly "Ana".
If you are replacing names or codes, you almost always want entire cell.
Regular expressions
For what Excel's find and replace cannot do. Some examples:
\s+$strips trailing spaces from every cell.^0+removes leading zeros.[^0-9]deletes everything that is not a digit.
If you do not know what these are, leave it off: the normal mode covers most cases and holds no surprises.
Frequently asked questions
Can I delete text instead of replacing it?
Yes. Leave the replacement field empty and the text found disappears.
Does it affect numbers?
Only if they match what you searched for. And if the result is a number again, it is stored as a number: replacing "1,234" with "1234" leaves a summable cell, not text.
Can it be limited to one column?
Yes, name it under "columns to search". Empty means the whole sheet.
What if my regular expression is too slow?
There is a per-cell time limit. If it is exceeded, the tool stops and tells you instead of leaving the server stuck.