Excel Find and Replace Results: Export Matches and Cells

Excel does not have a one-click command to export the results of Find and Replace as a separate report. In desktop Excel, use Find All to locate matching cells; for a dependable export, copy a filtered helper-column list or use a short VBA macro to write each matching cell’s address and value to a new worksheet.

What Excel Find All actually gives you

Find and Replace is designed to search or change workbook content, not to produce an export file. The Find tab can show a list of matches through Find All, including the worksheet and cell reference for each result. That list is useful for reviewing matches and jumping to them, but the dialog does not offer a Save Results or Export Results button.

To search in Microsoft Excel for Microsoft 365 on Windows, press Ctrl+F, enter the text, and choose Find All. You can also use Home > Find & Select > Find. In the expanded Find and Replace dialog, More > Within lets you choose the current sheet or the workbook, while Look in controls whether Excel searches values, formulas, or comments/notes where available. These choices affect what counts as a match.

Find All is not the same as a report. It identifies matching cells, but it does not automatically create a tidy table with one result per row, preserve the search settings, or record the matched substring separately from the cell’s full contents. If the goal is an audit trail or a file to send to somebody else, create a worksheet-based list instead.

Review and select matches with Find All

For a quick one-time search, Find All is usually the fastest route. Enter a term, select Find All, and review the results list. Selecting a listed result takes you to its cell. On Windows, you can click in the results list and use Ctrl+A to select the listed matches; close the dialog to see the selected cells on the sheet. Because this selection may consist of separate, non-adjacent cells, it is best treated as a way to inspect or format matches, not as a guaranteed export method.

Before searching, decide whether you need a case-sensitive search or whole-cell matches. In More, Excel provides Match case and Match entire cell contents options. For example, searching for “east” with Match entire cell contents off can find “Northeast region”; with it on, that cell is not a match. Searching with Match case on distinguishes “East” from “east.”

Use Find All when you need to navigate through matches or confirm how many cells are affected.
Use Find Next when you only need to inspect a few occurrences one at a time.
Choose the correct workbook or sheet scope before searching; a current-sheet search can miss matches elsewhere.
Check Look in if a cell displays a value that differs from the formula stored in it.

On a Mac, Command+F opens Find; Control+H is commonly used for Replace. The exact dialog layout can differ from Windows, so look for the Find All control in the Find and Replace window. Excel for the web has a more limited interface than desktop Excel; if you cannot access the same Find All controls, open the workbook in the desktop app or use a worksheet-based method.

Why copying the Find All list can be awkward

The results shown inside the dialog are not ordinary worksheet cells. You generally cannot select the dialog’s list and paste it into a new sheet as a clean table of addresses and values. Selecting the matching cells in the worksheet is also different from copying a continuous range: matches may be scattered across rows, columns, or sheets, and Excel’s copy and paste behavior for multiple selections can be restrictive.

For a handful of matches, use the result list to visit each cell and record its address and content manually. If you need dozens or hundreds of matches, create a helper column or use a macro. Those approaches make the output a normal Excel range that can be filtered, copied, saved as a separate workbook, or exported through File > Save As in a format such as CSV.

Keep in mind that a CSV file stores plain tabular values, not the workbook’s formulas, formatting, multiple sheets, or search settings. Save a copy of the workbook as an Excel file first if those details matter.

Create a reusable list with a helper column

A helper formula is a good no-macro option when you want to find rows containing a term in one or more columns. It does not reproduce the Find All dialog’s address list; instead, it marks each row that contains the search text so you can filter and export those rows. This is often more useful when the data is a table of records and the matching record, rather than every individual cell, is what you need.

Assume the records occupy A2:D100 and the search term is in F1. Put a heading such as “Match?” in E1. With the values to search in A2:D2 and the term in F1, enter this in E2 and fill it down through E100:

=COUNTIF(A2:D2,"*"&$F$1&"*")>0

For the example, if F1 contains “north” and row 2 has “Northern Sales” in B2, the formula returns TRUE; if none of A2:D2 contains that text, it returns FALSE. COUNTIF is not case-sensitive, and the asterisks mean that the term can appear anywhere within a cell. Filter column E to TRUE, then copy the visible rows to a new worksheet. To show the filter controls, select the data and use Data > Filter.

This formula checks each row as a unit: it does not tell you which of the four cells matched, and it returns only one TRUE even if several cells in that row contain the term. It also treats asterisks and question marks in the search term as wildcard characters. If your search text can contain those characters and must be treated literally, use Find All or build a formula that escapes wildcard characters before using COUNTIF.

Export individual matching cells with VBA

If the deliverable must contain one row per matching cell, a small macro can scan the active sheet and write the source sheet, cell address, and displayed value into a results worksheet. The example below searches cell values for a case-insensitive substring. It does not search formulas as text, comments, or every sheet in the workbook; run it separately on each sheet if needed. The macro adds a new results sheet, so save a copy of the workbook before running it. Macros cannot be undone with Ctrl+Z.

Open the Visual Basic Editor with Alt+F11 on Windows, choose Insert > Module, and paste the code into the module. On a Mac, the Visual Basic Editor shortcut depends on the keyboard and Excel settings; use Tools > Macro > Visual Basic Editor if the shortcut is unavailable. Save the workbook as an Excel Macro-Enabled Workbook (.xlsm) if you want to keep the macro.

Sub ExportMatchingCells()
    Dim sourceSheet As Worksheet
    Dim resultsSheet As Worksheet
    Dim cell As Range
    Dim searchText As String
    Dim nextRow As Long

    ' Search the active sheet's cell values for a substring.
    Set sourceSheet = ActiveSheet
    searchText = InputBox("Text to find:")
    If Len(searchText) = 0 Then Exit Sub

    Set resultsSheet = Worksheets.Add(After:=Worksheets(Worksheets.Count))
    resultsSheet.Name = "FindResults_" & Format(Now, "hhmmss")
    resultsSheet.Range("A1:C1").Value = Array("Sheet", "Cell", "Value")
    nextRow = 2

    For Each cell In sourceSheet.UsedRange.Cells
        If Not IsError(cell.Value2) Then
            If InStr(1, CStr(cell.Value2), searchText, vbTextCompare) > 0 Then
                resultsSheet.Cells(nextRow, 1).Value = sourceSheet.Name
                resultsSheet.Cells(nextRow, 2).Value = cell.Address(False, False)
                resultsSheet.Cells(nextRow, 3).Value = cell.Value2
                nextRow = nextRow + 1
            End If
        End If
    Next cell
End Sub

The macro compares the cell’s calculated value, so a formula cell is tested by its result rather than by the formula expression. If you need to search multiple worksheets, include an outer loop through the workbook’s Worksheets collection and record each source sheet in the output. Review the output before sharing it: the results sheet contains values and references, not a live connection to the original cells.

Choose a method based on the result you need

The best approach depends on whether “results” means a list of matching cells, a list of affected records, or the changed workbook after replacement. For an occasional check, Find All is convenient. For reusable reporting, a helper column is transparent and easy to filter. For a cell-by-cell inventory, VBA can produce a structured output, but it requires macro permissions and a careful review of its search scope.

Just locate matches: Find All, with the correct sheet scope and search options.
Export whole records: A helper formula, followed by a filter and copy to a new sheet.
Export each matching cell: A macro or a purpose-built data transformation process.
Keep a record of replacements: Save a pre-change copy and create a separate comparison or audit log; Find and Replace itself does not create a change history report.

For a larger or recurring transformation, Power Query may be a better alternative than repeated manual searches. It can load source data, filter rows, and produce a refreshable output table. It is designed for data preparation rather than a direct export of Find All’s cell-by-cell search results, so it is most useful when your source is structured and the same process will be repeated.

Common problems and safeguards

A missing match is often a settings issue rather than a failure in the data. Check whether the search is limited to the active sheet, whether Match case or Match entire cell contents is enabled, and whether Look in is set to values or formulas as intended. A displayed number can also be stored differently from what you see because of formatting; searching for a formatted display such as “$1,000” may not behave like searching for the underlying numeric value.

Find and Replace can also modify more than intended. Before choosing Replace All, confirm the search scope and options, and consider using Find All first to inspect the affected cells. If the workbook is important, save a separate copy before replacing text. Ctrl+Z can undo many normal replacement actions in desktop Excel, but it is not a substitute for a backup, especially after other actions or when automation is involved.

Formulas in the helper-column approach have their own limits. COUNTIF’s wildcard search is case-insensitive and is intended for text matching; it is not a byte-for-byte audit of all cell types. Blank search terms can produce misleading results, so put a nonblank term in F1. If the data contains errors, the COUNTIF approach generally counts matching text rather than evaluating an error as text, while the VBA sample explicitly skips error-valued cells.

Frequently Asked Questions

Can I export Find All results directly to Excel?
There is no built-in export button for the Find All dialog’s results list. Use the list to navigate or select matches, then create an exportable worksheet list with a helper column or VBA.

Can I copy the Find All results list and paste it into a worksheet?
The dialog list is not a normal worksheet range that Excel can reliably paste as a report. Selecting matching cells may be possible, but scattered selections are not a dependable way to create a clean table. Use a formula or macro when you need addresses and values together.

How do I find and export matching rows rather than cells?
Add a helper column that checks each record for the search term, filter the helper column to TRUE, and copy the visible records to a new sheet. This exports entire rows, including fields that did not contain the search text.

Does Find All search every worksheet?
It can search the current sheet or the workbook, depending on the Within setting in the expanded dialog. Confirm that setting before relying on the result count.

Can I export the results of Replace All?
Replace All changes matching content but does not generate a separate list of old values, new values, or changed cell addresses. Preserve a pre-change copy, or create a comparison or logging process before making replacements if an audit trail is required.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.