Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • How to Sort by Color in Excel
  • Create Scatter Chart in Excel
  • Calculate Conditional Percentile ‘IF’ in table in Excel
  • How To Load Analysis ToolPak in Excel
  • How to Create Gantt Chart in Excel

References

  • Merge tables with VLOOKUP in Excel
  • Perform case-sensitive Lookup in Excel
  • Extract all partial matches in Excel
  • CHOOSE function: Description, Usage, Syntax, Examples and Explanation
  • Excel Advanced Lookup using Index and Match Functions

Data Validations

  • Excel Data validation date in specific year
  • Excel Data validation specific characters only
  • Excel Data validation no punctuation
  • Excel Data validation only dates between
  • Excel Data validation must begin with

SUBSTITUTE function vs REPLACE function in Excel

by

This example shows the difference between the SUBSTITUTE function and the REPLACE function.

1a. If you know the text to be replaced, use the SUBSTITUTE function.

Worked Example:   REPLACE, REPLACEB functions: Description, Usage, Syntax, Examples and Explanation

1b. The SUBSTITUTE function has a 4th optional argument. You can use this argument to indicate which occurrence you want to substitute.

Worked Example:   Get workbook name and path without sheet in Excel

2. If you know the position of the text to be replaced, use the REPLACE function.

Worked Example:   Get position of 2nd 3rd and more instance of character in Excel

Note: started at position 1 with length 3.

Post navigation

Previous Post:

Complete List of Excel Cube Functions References and Examples

Next Post:

Excel Bar Chart

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • Excel If, Nested If, And/Or Criteria Examples
  • How to use Excel AND Function
  • IF, AND, OR and NOT Functions Examples in Excel
  • How to use Excel XOR Function
  • Return blank if in Excel

Date Time

  • Display Days until expiration date in Excel
  • How to calculate next day of week in Excel
  • Count holidays between two dates in Excel
  • Convert Excel time to decimal hours in Excel
  • How to get number of days, weeks, months or years between two dates in Excel

Grouping

  • Categorize text with keywords in Excel
  • Calculate conditional mode with criteria in Excel
  • How to randomly assign people to groups in Excel
  • Group times into 3 hour buckets in Excel
  • Running count group by n size in Excel

General

  • How to fill cell ranges with random number from fixed set of options in Excel
  • Print Excel Sheet In Landscape Or Portrait
  • Find, Select, Replace and Go To Special in Excel
  • How to choose page/paper size in Excel before Printing
  • Lock Cells in a Worksheet Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning