Advanced Excel Course Text Function Notes Set 01

Official Study Materials for Computer Science

Review targeted academic resources with the Advanced Excel Course Text Function Notes Set 01. Built according to official standards for the 2026-27 term, these downloadable Computer Science study materials support effective daily practice and deeper conceptual understanding for MS Office.

Advanced Resources for Computer Science

Access the complete useful resource PDF for Computer Science below. Regular practice with these targeted academic notes builds familiarity with complex topics and helps secure higher marks in final school evaluations.

Ten text functions of Excel are shown with worked examples: UPPER, LOWER, PROPER, TRIM, LEFT, MID, RIGHT, LEN, CONCATENATE and EXACT, each with its formula and a table of inputs and results.

Text Functions

Text functions change or pick parts of text. In every example below the formula is typed in the first cell of the result column and copied down.

UPPER

=UPPER(A2)

Converts all the letters of the text to capital letters.

NameAgeUpper
jOhn19JOHN
Smith16SMITH
Jackson18JACKSON
fisCHer16FISCHER
mahin Alam12MAHIN ALAM
emma12EMMA
aleXANder20ALEXANDER
Suzzane15SUZZANE
Peter19PETER
ColBy p Ford20COLBY P FORD

LOWER

=LOWER(A2)

Converts all the letters of the text to small letters.

TextLower
Documentdocument
INserTinsert
ALGORITHMalgorithm
Data Miningdata mining
FirEwallfirewall
Frequentlyfrequently
HACKERhacker
backupbackup
APPLIcationapplication
Notebook Computernotebook computer

PROPER

=PROPER(A2)

Changes the first letter of every word to a capital letter and the rest to small letters.

Full NameProper
mr. Haider AliMr. Haider Ali
MISS. OLIVIAMiss. Olivia
Ram kumar singhRam Kumar Singh
Chhaya yadavChhaya Yadav
Anita singh yadavAnita Singh Yadav
skylar rubYSkylar Ruby
ALICE CORAAlice Cora
MAhIN aLAMMahin Alam
shaziya zaidiShaziya Zaidi
shahban AbbasShahban Abbas

TRIM

=TRIM(A2)

Removes the extra spaces from the text: the spaces before and after it, and all but one of the spaces between words.

TitleTrim
The Shawshank Redemption (1994)The Shawshank Redemption (1994)
The Godfather (1972)The Godfather (1972)
The Godfather: Part 2nd (1972)The Godfather: Part 2nd (1972)
Pulp Fiction (1994)Pulp Fiction (1994)
The Good, The Bad and the Ugly (1966)The Good, The Bad and the Ugly (1966)
12 Angery Men (1957)12 Angery Men (1957)
Fight Club (1999)Fight Club (1999)

LEFT

=LEFT(A2,4)

Returns the stated number of characters from the left (start) of the text. The number of characters is the second argument and differs from row to row in this example.

NamesLeft
Syed Abid AliSyed
David WarnerDavid Warner
M.S DhoniM.S
Virat KohliVirat Ko
Adam ZampaAdam Z
Ricky PontingRic
Mohd ShamiMohd
Josh HazlewoodJosh Haz
Adil RashidAdi
Jonny BairstowJonny Bair

MID

=MID(A2,9,15)

Returns characters from the middle of the text. The arguments are the text, the starting position and the number of characters. Here the web address https://mail.google.com/mail.u gives the domain name.

WebsitesMid
https://mail.google.com/mail.umail.google.com
https://www.bigrock.in/dod?gclid=www.bigrock.in
https://eralamshahbaz.comeralamshahbaz.com
https://web.whatsapp.com/whatsapp.com
https://smallpdf.com/pdf-to-jpgsmallpdf.com

RIGHT

=RIGHT(A2,4)

Returns the stated number of characters from the right (end) of the text.

NamesRight
Syed Abid Ali Ali
David WarnerDavid Warner
M.S Dhonioni
Virat Kohliat Kohli
Adam Zampa Zampa
Ricky PontingPonting
Mohd Shamihami
Josh Hazlewoodazlewood
Adil Rashidhid
Jonny Bairstowy Bairstow

LEN (Length)

=LEN(A2)

Counts the characters in the text, including the spaces.

NamesLength
Zainab Rizvi12
Amit Tyagi10
Shahid Kapoor13
Dennis Ritchie14
Nusbeeha Naqvi14
James Thomas12
Eli Christian13
Jameson7
Ravi Kumar10
Shivi Singh11

CONCATENATE

=CONCATENATE(A2," ",B2," ",C2)

Joins the text of several cells into one. A space in quotation marks is placed between the parts.

First NameMiddle NameLast NameFull Name (Concatenate)
MohdAliAlamMohd Ali Alam
EshikaSinghYadavEshika Singh Yadav
AmitKumarTyagiAmit Kumar Tyagi
InayaAnsariInaya Ansari
LiyanaZaidiLiyana Zaidi
MohdMahinAlamMohd Mahin Alam
StDennisRitchieSt Dennis Ritchie
MissAliyaNaqviMiss Aliya Naqvi
MissSheezaAnsariMiss Sheeza Ansari
NainaBhardwajNaina Bhardwaj

EXACT

=EXACT(A2,B2)

Compares two texts and returns TRUE only when they are exactly the same (including capital and small letters), otherwise FALSE.

Data 1Data 2Exact
DocumentInkFALSE
PaperPaperTRUE
PenPencilFALSE
AC1500AB1500FALSE
PrinterPrintersFALSE
ScannerScannerTRUE
158158TRUE
SMPSPowerFALSE
KeyboardPressFALSE
Mouse PadPadFALSE

Free CBSE Study Guides: Computer Science MS Office

Quick Revision Material for MS Office

Access comprehensive study material for MS Office, including revision notes, concept maps, and high-probability questions. These resources are designed in alignment with the latest 2026 CBSE syllabus for Computer Science to support effective exam preparation.

Expert Notes and Solved Exam Questions

Built using official NCERT guidelines for Computer Science, these materials provide reliable academic support. Integrating past examination questions and step-by-step solutions helps students understand official CBSE grading criteria.

Additional Study Resources for

Wrap up your chapter revision by testing your knowledge against standard objective question formats. Explore our full library of free, up-to-date sample papers and online assessments to secure top grades in your CBSE examinations.

FAQs

Where can I find the most advanced study material for [current-page:node:field_board] [current-page:node:field_class] Computer Science for 2026-27?

The latest 2026-27 advanced study resources for Computer Science are available for free on StudiesToday.com which includes NCERT Exemplars, high-order thinking skills (HOTS) questions, and deep-dive concept summaries.

What does the 2026-27 Computer Science study package for [current-page:node:field_class] include?

Our exhaustive Computer Science package includes chapter wise revision notes, solved practice sheets, important formulas and Concept Maps to help in better understanding of all topics.

Is this study material enough for both [current-page:node:field_board] exams and competitive tests?

Yes. For , our resources have been developed to help you get better marks in school exams and also build fundamental strength needed for entrance tests including Competency Based learning.

How should [current-page:node:field_class] students use this Computer Science material for maximum marks?

in , students should use Active Recall method, read the concept summary, then solve the Important Questions section without looking at the answers and then check your answers.

Can I download [current-page:node:field_class] Computer Science study notes in PDF for offline use?

All Computer Science study materials are provided in mobile-friendly PDF. You can download and save them on your device.

Are the [current-page:node:field_class] Computer Science resources updated for the latest NEP guidelines?

Yes, our team has ensured that all Computer Science materials for are strictly aligned with the National Education Policy (NEP) 2020 and the latest 2026-27 syllabus.