Scribd
Upload
6 views2 pages

Functions

The document outlines various pre-defined and user-defined functions, focusing primarily on text functions. It provides detailed explanations and examples of text functions such as UPPER, LOWER, PROPER, LENGTH, LEFT, RIGHT, MID, TRIM, CONCATENATE, FIND, SEARCH, REPLACE, and SUBSTITUTE. Each function is described with its purpose and syntax for use in data manipulation.

Uploaded by

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

Functions

The document outlines various pre-defined and user-defined functions, focusing primarily on text functions. It provides detailed explanations and examples of text functions such as UPPER, LOWER, PROPER, LENGTH, LEFT, RIGHT, MID, TRIM, CONCATENATE, FIND, SEARCH, REPLACE, and SUBSTITUTE. Each function is described with its purpose and syntax for use in data manipulation.

Uploaded by

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

FUNCTIONS

PRE- DEFINED FUNCTIONS USER – DEFINED FUNCTIONS

1. TEXT FUNCTIONS
2. MATHEMATICAL FUNCTIONS
3. LOGICAL FUNCTIONS
4. DATE FUNCTIONS

TEXT FUNCTIONS :

1. UPPERCASE: IT CONVERTS INTO THE CAPITAL LETTER


UPPER(A2)
2. LOWERCASE: IT CONVERTS INTO THE SMALL LETTERS

LOWER (B3)
3. PROPER CASE : IT CONVERTS THE DATA INTO THE PROPER
ORDER
PROPER (C3)
4. LENGTH : IT USED TO FIND OUT THE LENGTH OF WORD,
SENTENCE
LEN (D2)
5. LEFT : IT GIVES THE LEFT SIDE CHARACTERS IN THE WORD
LEFT (A3,3)
GORGEOUS = LEFT (A2, 3) ---- GOR
6. RIGHT : IT GIVES THE RIGHT SIDE CHARACTERS IN THE
WORD
RIGHT ( A4, 4)
7. MID : IT GIVES THE MIDDLE CHARACTERS IN THE WORD
= MID(A3,3,4)
A3 – CELL REFERENCE
3 – START NUM
4 --- NUM OF CHARACTERS

GORGEOUS = RGEO

8. TRIM: IT USED TO CUT THE SPACES IN SIDES


= TRIM(A4)

9. CONCATENATE: COMBINING THE STRINGS , WORDS,


SENTENCES
CONCATE OR CONCATENATE
= CONCATE (A2,B2,C2,D2)
= CONCATE ( “ MSOFFICE”,B3)
= CONCATE ( “ MSOFFICE”, “,” B3)
10.FIND : IT USED TO FIND SOMETHNG
= FIND( “S”, A3)
11.SERACH : SEARCH (“A”, B3)
12.REPLACE : REPLACE( A2, 1,3,”SEARCH “)
A2 ----- OLD TEXT
1 ---- START
4 ---- NO ‘ OF CHARACTERS
“ SEARCH ”
13.SUBSTITUTE : SUBSTITUTE ( A2, “A”, “SEARCH”)
A2—SEERCH

You might also like