27 functions for this use case · out of 12 defined
Returns a numeric code for the first character in a text string. The returned code corresponds to the character set used by your computer.
Checks whether an input value is text or not?
Returns the number (code point) corresponding to the first character of the text.
Checks whether a value is numeric or not?
Learn about the UNIQUE function, which returns a list of unique values in a list or range. UNIQUE is in a class of functions called dynamic arrays.
Converts a text string that represents a number to a number.
The DATEVALUE function converts a date that is stored as text to a serial number that Excel recognizes as a date. For example, the formula =DATEVALUE("1/1/2008") returns 39448, the serial number of the date 1/1/2008. Remember, though, that your computer's system date setting may cause the results of a DATEVALUE function to vary from this example The DATEVALUE function is helpful in cases where a worksheet contains dates in a text format that you want to filter, sort, or format as dates, or use in date calculations. To view a date serial number as a date, you must apply a date format to the cell. Find links to more information about displaying numbers as dates in the See Also section.
How to use the FILTER function in Excel to filter a range of data based on criteria you define.
LEN returns the number of characters in a text string.
Converts all uppercase letters in a text string to lowercase.
REGEXTEST Function
Substitutes new_text for old_text in a text string. Use SUBSTITUTE when you want to replace specific text in a text string; use REPLACE when you want to replace any text that occurs in a specific location in a text string.
Returns the decimal number of the time represented by a text string. The decimal number is a value ranging from 0 (zero) to 0.99988426, representing the times from 0:00:00 (12:00:00 AM) to 23:59:59 (11:59:59 P.M.).
The TRIMRANGE function excludes all empty rows and/or columns from the outer edges of a range or array.
REPLACE replaces part of a text string, based on the number of characters you specify, with a different text string.
Capitalizes the first letter in a text string and any other letters in text that follow any character other than a letter. Converts all other letters to lowercase letters.
TEXTSPLIT function
Converts text to uppercase.
Returns the character specified by a number. Use CHAR to translate code page numbers you might get from files on other types of computers into characters.
This article shows you how REGEXEXTRACT function allows you to extract text from a string based on a supplied regular expression.
REGEXREPLACE Function
Value returned if no match is found. By default, #N/A is returned.
Returns the Unicode character that is referenced by the given numeric value.
Removes all nonprintable characters from text. Use CLEAN on text imported from other applications that contains characters that may not print with your operating system. For example, you can use CLEAN to remove some low-level computer code that is frequently at the beginning and end of data files and cannot be printed.
Value returned if no match is found. By default, #N/A is returned.
Scan the array by column. By default, the array is scanned by row. Scanning determines whether the values are ordered by row or by column.
Removes all spaces from text except for single spaces between words. Use TRIM on text that you have received from another application that may have irregular spacing.