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. ...
NUMBERVALUE function.Converts strings of numeric notation (decimal points and commas) from various linguistic regions to numerical values.
Functions for converting strings of numbers expressed in different formats to numeric values.
VALUE Function. Converts a numeric value or date/time entered as a string to a numeric value (serial value of date/time).
The VALUE function converts a number or date entered as a string to a numeric value or a serial date/time value.
FIXED Function. Round a number to the specified number of digits. Then converted to a comma-separated string.(Microsoft Excel)
The FIXED function converts a number to a comma-separated string.
How to convert a word to first letter only, all uppercase, or all lowercase.(Microsoft Excel)
Here are some functions that manipulate strings of English words.
TRIM Function. Remove unnecessary spaces between and before and after words, leaving one space between words.(Microsoft Excel)
The TRIM function removes all unnecessary spaces in a sentence.
It is suitable for formatting data imported from ...