Hello All. In this section, let’s look into all the Text functions available. Here is the table with the usage and syntax for all the Text functions in Excel
Function | Usage | Syntax |
CHAR | Return a specific character based on the numerical value input | =CHAR(number) |
CLEAN | Removes all non-printable characters from the text | =CLEAN(text) |
CODE |
Returns the numeric code for the first character in the text string | =CODE(text) |
CONCAT | Joins a list or range of text strings | =CONCAT(text1, text2,…) |
CONCATENATE | Joins several text strings into one | =CONCATENATE(text1, text2,…) |
DOLLAR |
Convert a number to text in currency format | =DOLLAR(number,[decimals]) |
EXACT | Compare 2 x text strings | =EXACT(text1, text2) |
FIND | Returns the location of text in a text string. Case sensitive | =FIND(text, within text, [starting number]) |
FIXED | Format the number with fixed decimals | =FIXED(number, [decimals], [no_commas]) |
LEFT | Returns the specified number of characters from start of text string | =LEFT(text,[num_chars]) |
LEN | Get the length of the text string | =LEN(text) |
LOWER | Convert the text string to lower case | =LOWER(text) |
MID | Extract characters from middle of the text string, given the starting position and length | =MID(text, start_num, num_chars) |
NUMBERVALUE | Converts a number in text format to numeric value | =NUMBERVALUE(text,[decimal separator],[group separator]) |
PROPER | Capitalize the first letter in each word | =PROPER(text) |
REPLACE | Replace text string with another text string | =REPLACE(old text, start_num, num_chars, new text) |
REPT | Repeat text a given number of times | =REPT(text, number_times) |
RIGHT | Returns the specified number of characters towards end of a text string | =RIGHT(text, [num_chars]) |
SEARCH | Returns the location of text in a string (From left to right) | =SEARCH(find text,within text, [start num]) |
SUBSTITUTE | Replace existing text with new text in the text string | =SUBSTITUTE(text, old text, new text, [instance num]) |
TEXT | Converts a value to text in a specified number format | =TEXT(value, format_text) |
TEXTJOIN | Concatenates a list or range of text strings with a delimiter | =TEXTJOIN(delimiter, ignore empty, text1, text2,…) |
TRIM | Remove spaces from text except for single space between words | =TRIM(text) |
UNICHAR | Get Unicode character by number | =UNICHAR(number) |
UNICODE | Get number corresponding to the first character of the text | =UNICODE(text) |
UPPER | Convert text into upper case | =UPPER(text) |
VALUE | Convert a number in text format into a number format | =VALUE(text) |
I hope you liked this one pager about all the Text functions in Excel. Shortly, I will insert hyperlink for each of the function explaining them in detail.
Please provide us with your valuable feedback to improve the content. Thanks for reading.