!text,old_text,new_text,instance_num!!Replaces existing text with new text in a text string!is the text or the reference to a cell containing text in which you want to substitute characters!is the existing text you want to replace. If the case of Old_text does not match the case of text, SUBSTITUTE will not replace the text!is the text you want to replace Old_text with!specifies which occurrence of Old_text you want to replace. If omitted, every instance of Old_text is replaced!
text,num_bytes!Returns the specified number of characters from the end of a text string. Use with double-byte character sets ...
text,num_bytes!Returns the specified number of characters from the start of a text string. Use with double-byte character ...
text,num_chars!Returns the specified number of characters from the end of a text string!is the text string that contains ...
text,num_chars!Returns the specified number of characters from the start of a text string!is the text string containing the ...
text,old_text,new_text,instance_num!Replaces existing text with new text in a text string!is the text or the reference to ...
text,start_num,num_bytes!Returns characters from the middle of a text string, given a starting position and length. Use with ...
text,start_num,num_chars!Returns the characters from the middle of a text string, given a starting position and length!is ...
text1,text2!Checks whether two text strings are exactly the same, and returns TRUE or FALSE. EXACT is case-sensitive!is the ...
text1,text2,.!Joins several text strings into one text string!are 1 to 255 text strings to be joined into a single text string ...