SEARCH Function. Finds the position of the specified character.(Microsoft Excel)
The SEARCH function is used to find out how many characters of a given string exist.
It is similar to the FIND fu ...
CLEAN function. Delete unprintable characters.(Microsoft Excel)
This function returns a string that has had line feeds in cells, tab characters, and control characters that were inc ...
EXACT function. compares if two strings are the same.(Microsoft Excel)
Japanese version.
The EXACT function compares two strings and returns TRUE if they match, Otherwise, it returns ...
CODE Function. Get the numeric code of a character.(Microsoft Excel)
What is displayed as a character is also treated internally by the computer as a number.
The CODE function retr ...
CHAR Function. Get the character corresponding to a numeric code.(Microsoft Excel)
What is displayed as a character is also treated internally by the computer as a number.
TEXTJOIN function. Concatenates strings by specifying a delimiter.(Microsoft Excel)
The TEXTJOIN function creates a concatenated string by specifying specific characters.
It is very effective whe ...
ARRAYTOTEXT Function. Convert an array (cell range) to text.
Japanese version.
Function to convert an array (cell range) to text. Currently, this function is of little use. ...
TRUNC function. Truncate a number to the specified number of digits or less.(Microsoft Excel)
The TRUNC function truncates a number less than a specified digit.
INT function. Convert decimals to integers.(Microsoft Excel)
The INT function converts a small number to an integer.
CEILING and FLOOR functions.Round up/down by multiples of specified value(Microsoft Excel)
The CEILING and FLOOR functions can be used to round up or down The CEILING and FLOOR functions can be used to round ...