1.
LEFT
Extracts a specified number of characters from the start of a text string.
Syntax: =LEFT(text, [num_chars])
Example: =LEFT("science", 4) → "scie"
2. RIGHT
Extracts a specified number of characters from the end of a text string.
Syntax: =RIGHT(text, [num_chars])
Example: =RIGHT("Data", 2) → "ta"
3. MID
Extracts a specified number of characters from the middle of a text string, starting at a specific
position.
Syntax: =MID(text, start_num, num_chars)
Example: =MID("Analytics", 2, 3) → "nal"
4. LEN
Returns the number of characters in a text string (including spaces).
Syntax: =LEN(text)
Example: =LEN("Excel Functions") → 15
5. FIND
Finds the position of a specific character or substring within a text string (case-sensitive).
Syntax: =FIND(find_text, within_text, [start_num])
Example: =FIND("e", "Excel") → 2
6. SEARCH
Similar to FIND, but it is not case-sensitive.
Syntax: =SEARCH(find_text, within_text, [start_num])
Example: =SEARCH("e", "Excel") → 1
7. CONCATENATE or TEXTJOIN (newer version)
Joins two or more text strings into one.
Syntax (CONCATENATE): =CONCATENATE(text1, [text2], ...)
Example: =CONCATENATE("Data", " ", "Analytics") → "Data Analytics"
Syntax (TEXTJOIN): =TEXTJOIN(delimiter, ignore_empty, text1, text2, ...)
Example: =TEXTJOIN(" ", TRUE, "Data", "Analytics") → "Data Analytics"
8. UPPER
Converts all characters in a text string to uppercase.
Syntax: =UPPER(text)
Example: =UPPER("excel") → "EXCEL"
9. LOWER
Converts all characters in a text string to lowercase.
Syntax: =LOWER(text)
Example: =LOWER("EXCEL") → "excel"
10. PROPER
Capitalizes the first letter of each word in a text string.
Syntax: =PROPER(text)
Example: =PROPER("data analysis") → "Data Analysis"
11. TRIM
Removes extra spaces from a text string, except for single spaces between words.
Syntax: =TRIM(text)
Example: =TRIM(" Excel Functions ") → "Excel Functions"
12. SUBSTITUTE
Replaces old text with new text within a string.
Syntax: =SUBSTITUTE(text, old_text, new_text, [instance_num])
Example: =SUBSTITUTE("Data Analytics", "Analytics", "Science") → "Data Science"
13. REPT
Repeats a text string a specified number of times.
Syntax: =REPT(text, number_times)
Example: =REPT("Hi", 3) → "HiHiHi"
14. TEXT
Converts a value to text in a specific number format.
Syntax: =TEXT(value, format_text)
Example: =TEXT(12345.678, "$#,##0.00") → "$12,345.68"
15. VALUE
Converts text that represents a number to a numeric value.
Syntax: =VALUE(text)
Example: =VALUE("12345") → 12345
These functions help in manipulating, formatting, and cleaning text data in Excel. Let me know if
you'd like detailed examples or further explanations!
4o