Category: Excel Function

The T function is to return the text value. When it is not text, the result returns a blank. Formula: =T(text) Explanations: The text is required, the text you …

The SUBSTITUTE function is to replace a specific text with another text string. Formula: =SUBSTITUTE(text, old_text, new_text, ) Explanations: – Text is required, which is the text containing the …

The SEARCH function searches a text string from another and returns the location in the second text string. For example, the result returns 2 when searching the text string …

The SEARCHB function is to search a text string from another and returns the location in the second text string. When a double-byte character set (DBCS, e.g., Japanese, Simplified …

The RIGHTB function returns the last characters in a text string based on the number of bytes you specified. When a double-byte character set (DBCS, e.g., Japanese, Simplified Chinese, …

The RIGHT function returns the last characters in a text string based on the number of characters you specified. Formula: =RIGHT(text, ) Explanations: – The text is required, the …