###### Excel SUBSTITUTE function

The Excel SUBSTITUTE function replaces existing test with new text in a text string. This function is useful for inserting text and/or correcting misspellings in Excel.

Skip to content###### Excel SUBSTITUTE function

###### Excel REPLACE function

###### Excel FIND function

###### Excel TRIM function

###### Excel SEARCH function

###### Excel LEN function

###### Excel CONCATENATE function

###### Excel MID function

###### Excel RIGHT function

###### Excel LEFT function

The Excel SUBSTITUTE function replaces existing test with new text in a text string. This function is useful for inserting text and/or correcting misspellings in Excel.

0 Comments

December 30, 2020

The Excel REPLACE function replaces part of a text string with a different text string.

December 30, 2020

The Excel FIND function returns a numerical value of the position of a text string within another text string.

December 30, 2020

The Excel TRIM function removes extra spaces from the beginning and end of a text string, as well as removes double spaces between characters.

November 7, 2020

The Excel SEARCH function returns a numerical value of the position of a text string within another text string.

November 1, 2020

The Excel LEN function returns the number of characters in a text string.

November 1, 2020

The Excel CONCATENATE function combines multiple text strings into a single text string.

November 1, 2020

The Excel MID function returns a specified number of characters from the middle of a text string.

October 31, 2020

The Excel RIGHT function returns a specified number of characters from the end (right side) of a text string.

October 31, 2020

The Excel LEFT function returns a specified number of characters from the start (left) of a text string.

October 31, 2020