DATA ANALYTICS
10 ESSENTIAL
TEXT
FUNCTIONS IN
EXCEL
DAY5 SIVADHANALAKSHMI RANIMEKALA
1. CONCATENATE FUNCTION
Definition: CONCATENATE joins together
multiple text strings into one.
Example: =CONCATENATE("Hello
", "world!")
combines "Hello" and "world!" into "Hello
world!".
SIVADHANALAKSHMI RANIMEKALA
2. LEFT FUNCTION:
Definition: LEFT extracts a specified
number of characters from the left side of
a text string.
Example: =LEFT("Excel", 3)
extracts the first three characters from
"Excel", resulting in "Exc".
SIVADHANALAKSHMI RANIMEKALA
3. RIGHT FUNCTION:
Definition: RIGHT extracts a specified
number of characters from the right side
of a text string.
Example: =RIGHT("Data", 2)
extracts the last two characters from
"Data", resulting in "ta".
SIVADHANALAKSHMI RANIMEKALA
4. MID FUNCTION:
Definition: MID extracts a specified
number of characters from the middle of a
text string.
MID
Example: =MID("Excel", 2, 3)
extracts three characters starting from the
second position in "Excel", resulting in
"xce".
SIVADHANALAKSHMI RANIMEKALA
5. LEN FUNCTION:
Definition: LEN returns the number of
characters in a text string.
Example: =LEN("Analytics")
returns the length of the text string
"Analytics", which is 9.
SIVADHANALAKSHMI RANIMEKALA
6. FIND FUNCTION:
Definition: FIND returns the starting
position of one text string within
another.
Example: =FIND("e", "Excel")
returns 2, as "e" is found at the second
position in "Excel".
SIVADHANALAKSHMI RANIMEKALA
7. SUBSTITUTE FUNCTION:
Definition: SUBSTITUTE replaces
occurrences of a specified text string
within another text string.
Example: =SUBSTITUTE("banana", "a", "o")
replaces all instances of "a" with "o" in
"banana", resulting in "bonono".
SIVADHANALAKSHMI RANIMEKALA
8. LOWER FUNCTION:
Definition: LOWER converts all letters in
a text string to lowercase.
Example: =LOWER("HELLO")
converts "HELLO" to "hello".
SIVADHANALAKSHMI RANIMEKALA
9. UPPER FUNCTION:
Definition: UPPER converts all letters in a
text string to uppercase.
Example: =UPPER("world")
converts "world" to "WORLD".
SIVADHANALAKSHMI RANIMEKALA
10. PROPER FUNCTION:
Definition: PROPER converts the first
letter of each word in a text string to
uppercase.
Example: =PROPER("data analysis")
converts "data analysis" to "Data
Analysis".
SIVADHANALAKSHMI RANIMEKALA
SAVE IT IF YOU
FIND THIS POST
HELPFUL
1 MORE
POST ON
EXCEL
AWAITING!!
SIVADHANALAKSHMI RANIMEKALA
