Updated on 5 September 2026 · Works in Excel 365, 2021, 2019 and 2016 unless noted. Find and Replace in Excel locates any text, number or format in a sheet or workbook and, when you ask it to, swaps every match for something else in one pass. Press Ctrl+F to find and Ctrl+H to replace. … Continue reading Find and Replace in Excel: Complete Guide with Wildcards