In the previous post, we saw ‘Text Function | How to use the Excel MID Function?, now we will learn about how to use the Excel SUBSTITUTE function?’.

Where to Find the Text Function?

To find the text function in excel open excel and click on the “Blank” to open a blank excel worksheet now click on the ‘Formula Tab’ and under ‘Function Library’ click on the ‘Text’ option as shown below:

You can also see the text function via shortcut key – press ‘ALT + M + T’ after that select the text function that you want to use.

What is Excel SUBSTITUTE Function?

The Excel SUBSTITUTE Function substitutes new_text for old_text in a text string. Use SUBSTITUTE when you want to replace specific text in a text string; use REPLACE when you want to replace any text that occurs in a specific location in a text string.

Syntax

SUBSTITUTE(text, old_text, new_text, [instance_num])

Arguments

The SUBSTITUTE function syntax has the following arguments:

Text    Required. The text or the reference to a cell containing text for which you want to substitute characters.

Old_text    Required. The text you want to replace.

New_text    Required. The text you want to replace old_text with.

Instance_num    Optional. Specifies which occurrence of old_text you want to replace with new_text. If you specify instance_num, only that instance of old_text is replaced. Otherwise, every occurrence of old_text in text is changed to new_text.

Understand With Example

If you want to make the lower case, The Excel LOWER function Converts all uppercase letters in a text string to lowercase. It ignores space, numbers, and punctuation. Visit this link – Excel LOWER Function.

The Excel PROPER function Capitalizes the first letter in a text string and any other letters in the text that follow any character other than a letter. It Converts all other letters to lowercase letters. Visit this link – Excel PROPER Function

For Latest Updates & Learning Join Our YouTube Channel: Join Now