.png)
100 Nos Of Formula and Functions
In MSExcel
Part 3
41-60: Text Functions
41. CONCATENATE - Joins multiple
strings into one.
o Example: =CONCATENATE(A1,
B1)
42.TEXTJOIN - Joins text with a
delimiter.
o Example: =TEXTJOIN(",
", TRUE, A1:C1)
43.LEFT - Extracts a specific number of
characters from the left.
o Example: =LEFT(A1, 5)
44.RIGHT - Extracts characters from the
right.
o Example: =RIGHT(A1, 3)
45.MID - Extracts characters from the
middle of a string.
o Example: =MID(A1, 2, 3)
46.LEN - Returns the length of a text
string.
o Example: =LEN(A1)
47.TRIM - Removes extra spaces.
o Example: =TRIM(A1)
48.LOWER - Converts text to lowercase.
o Example: =LOWER(A1)
49.UPPER - Converts text to uppercase.
o Example: =UPPER(A1)
50.PROPER - Capitalizes the first
letter of each word.
o Example: =PROPER(A1)
51. REPT - Repeats text a
specified number of times.
o Example:
=REPT("*", 5)
52.SUBSTITUTE - Replaces specific text.
o Example: =SUBSTITUTE(A1,
"old", "new")
53.REPLACE - Replaces part of a text
string based on position.
o Example: =REPLACE(A1, 2,
3, "new")
54.FIND - Finds the position of text.
o Example:
=FIND("text", A1)
55.SEARCH - Finds position, case-insensitive.
o Example:
=SEARCH("text", A1)
56.TEXT - Formats a number as text.
o Example: =TEXT(A1,
"$#,##0.00")
57.DOLLAR - Formats a number as
currency.
o Example: =DOLLAR(A1, 2)
58.VALUE - Converts text to a number.
o Example: =VALUE(A1)
59.EXACT - Checks if two strings are
identical.
o Example: =EXACT(A1, B1)
60.CODE - Returns a character code.
o Example: =CODE(A1)
