• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Microsoft Excel Tips and Tricks - Computergaga

  • Home
  • Excel Online Courses
  • Excel Functions List
  • Free Downloads
  • Blog
  • Tutorials
  • About

Excel SUBSTITUTE Function

The Excel SUBSTITUTE function is used to replace existing characters with a different set of characters.

The syntax for the SUBSTITUTE function is:

= SUBSTITUTE (text, old text, new_text, [instance_num])

ArgumentPurpose
TextThe text or cell reference containing the text with the characters you want to change
Old_textmThe existing characters you want to replace.
New_textThe new characters to replace the old ones with
Instance_numThis argument is optional. It is the number of instances of the old_text that you want to replaceIf omitted, then every instance of old_text is replaced with the new_text

The examples below show the SUBSTITUTE function being used change the characters of an existing cell.

Excel SUBSTITUTE function to replace characters in a cell
FunctionResult
=SUBSTITUTE(A2,”Solo”,”Duo”)Hans Duo
=SUBSTITUTE(A3,”g”,”b”,1)Computerbaga
=SUBSTITUTE(A3,”g”,”n”)Computernana

Primary Sidebar

Popular Posts

  • Excel Fixtures and League Table Generator
  • 5 Reasons Why your Excel Formula is Not Calculating
  • Excel IF Function Contains Text – A Partial Match in a Cell
  • Excel Formula to Display the Sheet Name in a Cell
  • 4 Alternatives to Nested IF Formulas
  • How to Hyperlink to a Hidden Worksheet in Excel
  • How to Create a Reverse FIND Formula
  • Check if a Value is an Even Number
  • IF Function in Power Query Including Nested IFS
  • Conditional Formatting Multiple Columns – 3 Examples

Recent Posts

  • Non-Adjacent Columns with FILTER Function
  • Moving Average in Excel
  • Excel IMAGE Function – Insert Images from a Cell Value
  • SEQUENCE Function in Excel
  • Sort by Drop Down List in Excel
Advanced Excel Success book

Footer

Contact

[email protected]

Useful Links

  • Home
  • Excel Online Courses
  • Tutorials
  • Sitemap
  • Privacy Policy
  • Jobs by Jooble

Course Topics

  • Charts
  • Courses
  • Dashboards
  • Downloads
  • Excel Tips
  • Formulas
  • Mail Merge
  • Office
  • PivotTables
  • Power BI
  • Power Pivot
  • Power Query
  • VBA

Join Our Mailing List

© Copyright 2020 Computergaga · All Rights Reserved ·