Japanese version. Functions. Function to modify a string. Function Importance Description LEFTMIDRIGHT High Extracts a portion of a string by specifying the number of characters . LEFTBMIDBRIGHTB Low Extracts a portion of a string by specifying the number of bytes from the beginning. SUBSTITUTE High Replace the specified string. REPLACE Middle Replace specified character position & number of characters with specified string. TRIM Middle Remove unnecessary spaces between and before and after words, leaving one space between words. CLEAN Middle Delete characters that cannot be printed. CONCATENATE Low Concatenate strings (old version) CONCAT High Concatenate strings. TEXT Middle Get a string with display format code (user-defined format) applied to a … Continue reading Text(Microsoft Excel Functions)