[go: up one dir, main page]
Scribd
Upload
17 views8 pages

50 Excel Formulas For Data Analysts - Part 3

Uploaded by

sujanabellapukonda
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
17 views8 pages

50 Excel Formulas For Data Analysts - Part 3

Uploaded by

sujanabellapukonda
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 8

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

You might also like