Look up any Excel function — syntax, a real example, and when to use it.
Joins two or more pieces of text into one.
Returns the position where one piece of text starts inside another, and is case-sensitive.
Returns a specified number of characters from the start (left side) of a text string.
Returns the number of characters in a text string, including spaces.
Converts all letters in a text string to lowercase.
Returns a specific number of characters from the middle of a text string, starting at a position you choose.
Capitalizes the first letter of each word in a text string, converting the rest to lowercase.
Replaces a specific number of characters within a string, matched by position rather than by the text itself.
Returns a specified number of characters from the end (right side) of a text string.
Returns the position where one piece of text starts inside another, and is not case-sensitive.
Replaces occurrences of specific text within a string, matched by the text itself rather than its position.
Converts a number into text, displayed in a specific format you choose.
Joins multiple pieces of text together with a delimiter between each, optionally skipping empty cells.
Removes extra spaces from text, leaving only single spaces between words.
Converts all letters in a text string to uppercase.
Converts text that looks like a number into an actual number Excel can calculate with.