50 EXCEL
FORMULAS
FOR DATA
ANALYSTS
PART-1
PART -3 Swipe Right
@sakshi-savardekar10
13 LEN()
14 LEFT()
15 RIGHT()
16 PROPER()
17 UPPER()
PART-1
18 LOWER()
@sakshi-savardekar10
13 LEN()
Returns the length of a given text string
as the number of characters including space and punctuation
Syntax : =LEN(text)
Counts characters in numbers.
Number formatting is not included.
Returns zero if value is empty.
@sakshi-savardekar10
14 LEFT()
Extracts a given number of characters from the left
side of a text string
Syntax: =LEFT(text,[num_chars])
text - The text from which to extract characters.
num_chars - [optional]
The number of characters to extract, starting on the left. Default = 1.
LEFT is not case-sensitive.
Can extract numbers as well as text.
Ignores number formatting when extracting characters.
@sakshi-savardekar10
15 RIGHT()
Extracts a given number of characters from the right
side of a text string
Syntax: =RIGHT(text,[num_chars])
text - The text from which to extract characters.
num_chars - [optional]
The number of characters to extract, starting on the right. Default = 1.
RIGHT is not case-sensitive.
Can extract numbers as well as text.
Ignores number formatting when extracting characters .
@sakshi-savardekar10
16 PROPER()
Capitalizes each word in a given text string
Syntax : =PROPER(text)
First lowercases any uppercase letters, then capitalizes each
word in the provided text string.
Numbers, punctuation, and spaces are not affected.
Converts numbers to text with number formatting removed.
Formatting of date is lost.
@sakshi-savardekar10
17 UPPER()
Converts a text string to all uppercase letters
Syntax : =UPPER(text)
Numbers, punctuation, and spaces are not affected.
Converts numbers to text with number formatting removed.
Formatting of date is lost.
@sakshi-savardekar10
18 LOWER()
Converts a text string to all lowercase letters
Syntax : =LOWER(text)
Numbers, punctuation, and spaces are not affected.
Converts numbers to text with number formatting removed.
Formatting of date is lost.
@sakshi-savardekar10
