CHAPTER 10 · INTERMEDIATE EXCEL

Text & Date Functions

Real spreadsheets me names, codes, dates aur imported text clean karna common task hai. LEN, LEFT, RIGHT, UPPER/LOWER aur YEAR/MONTH/DAY jaise functions data ko useful parts me transform karte hain.

English + Hinglish30 minBrowser practice

LEN

text lengthExcel

=LEN(A2)

Text me kitne characters hain, ye return karta hai.

LEFT and RIGHT

extract textExcel

=LEFT(A2,5)
=RIGHT(A2,4)

Beginning ya end se fixed number of characters extract kar sakte ho.

UPPER and LOWER

case cleanupExcel

=UPPER(A2)
=LOWER(A2)

Imported text ka letter case normalize karne me useful.

Date parts

date analysisExcel

=YEAR(A2)
=MONTH(A2)
=DAY(A2)

Valid date se year, month aur day components nikal sakte ho. Date formatting aur actual stored date value ko confuse mat karo.

Hinglish

Text functions data cleaning me help karte hain; date functions reporting aur grouping me. Example: order date se year nikal kar yearly sales report banana.

Practice

Product code aur date extraction ke challenges Excel Lab me available hain.

Open Excel Lab →

Next: Intermediate foundation ke baad lookup functions, charts, Pivot Tables aur advanced data tools aayenge.