changing characters in excel Archives

Posted on August 27, 2019 by Armin Keshavarzi — Leave a comment

SUBSTITUTE function in Excel

SUBSTITUTE replaces part of a text string, based on the characters you specify, with a different text string. This function is categorized as a String/Text Function. In this video we described how to use SUBSTITUTE function in different situations.

Posted on August 26, 2019 by Armin Keshavarzi — Leave a comment

REPLACE function in Excel

REPLACE replaces part of a text string, based on the number of characters you specify, with a different text string. This function is categorized as a String/Text Function. In this video we described how to use REPLACE function in different situations.