About 466,000 results
Open links in new tab
  1. REPLACE function - Microsoft Support

    Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter.

  2. Using Excel REPLACE and SUBSTITUTE functions - formula examples - Ablebits

    Mar 21, 2023 · The tutorial explains the Excel REPLACE and SUBSTITUTE functions with examples of uses. See how to use the REPLACE function with text strings, numbers and …

  3. How to Replace Characters, Text, and Strings in Excel

    Aug 30, 2024 · The REPLACE function substitutes a text string with another text string. Learn all the steps here + a bonus method (sample file included).

  4. 6 Easy Ways to Replace Words in Excel Using Formula

    Oct 12, 2024 · Learn how to replace words in Excel using formulas like SUBSTITUTE, REPLACE, and SEARCH for efficient text replacement in your data.

  5. Excel REPLACE function | Exceljet

    Oct 22, 2025 · The Excel REPLACE function replaces characters specified by position in a given text string with another text string. For example, the following formula replaces the "123" at the …

  6. Excel REPLACE Function: Complete Text Replacement Guide with …

    Jun 9, 2025 · Master Excel's REPLACE function with this comprehensive guide. Learn syntax, examples, and advanced techniques for precise text replacement in your spreadsheets.

  7. Excel REPLACE Function - How To Use? Examples and Template.

    What Is REPLACE Function In Excel? The REPLACE function in Excel is a text function that is an inbuilt function similar to a substitute function. This function replaces an old text from a string …

  8. Excel REPLACE Function - ExtendOffice

    Oct 28, 2024 · Here, you should apply the TEXT function to convert the date format to text string firstly, and then use the REPLACE function. Please apply the following formula: Then, drag the …

  9. How to Use Excel REPLACE Function (Examples + Video)

    Replace is a text function that allows you to quickly replace a string or a part of the string with some other text string. This can be really useful when you’re working with a large dataset and …

  10. How to use Substitute and Replace Functions in Excel

    Feb 17, 2025 · In this tutorial, we will explain how to use the Substitute as well as the Replace function in Excel. The formula for the Substitute function is: The formula for the Replace …