Scribd
Upload
6 views2 pages

Excel Text Functions Lab

The document is a practice lab for Excel text functions, organized into sections with input examples and corresponding formulas for output. It covers functions such as PROPER, UPPER, LOWER, TRIM, LEFT, RIGHT, MID, and SUBSTITUTE, providing exercises for users to apply these functions. Each section includes specific tasks related to names, messy text, ID codes, addresses, and assessments.

Uploaded by

Jerry Oginni
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
6 views2 pages

Excel Text Functions Lab

The document is a practice lab for Excel text functions, organized into sections with input examples and corresponding formulas for output. It covers functions such as PROPER, UPPER, LOWER, TRIM, LEFT, RIGHT, MID, and SUBSTITUTE, providing exercises for users to apply these functions. Each section includes specific tasks related to names, messy text, ID codes, addresses, and assessments.

Uploaded by

Jerry Oginni
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

Excel Text Functions Practice Lab

Sheet Name: Text_Functions_Lab

Sec
tio
n A (Input) B (Output / Formula) C (Additional Exercise / Formula)
1 Raw Names Proper Case: =PROPER(A2) Upper Case: =UPPER(A2), Lower
Case: =LOWER(A2)
john doe
mary ann smith
PETER parker
2 Messy Text Trimmed Text: =TRIM(A2) Length: =LEN(TRIM(A2))
” john doe ”
” mary ann
smith ”
” PETER parker
”
3 ID Codes LEFT 3 chars: =LEFT(A2,3) RIGHT 3 chars: =RIGHT(A2,3), MID
4,4: =MID(A2,4,4)
ABC12345
XYZ98765
4 Addresses Replace text: Exercise: Replace first space with :
=SUBSTITUTE(A2,“Ave”,“Avenu =SUBSTITUTE(A2,” “,””,1)
e”)
123 Main Ave
456 Elm St
789 Oak Rd
5 Assessment Formula / Answer Column Notes / Hints
Questions
kAmilA joHnSon =PROPER(A2)
” data analyst ” =LEN(TRIM(A2)) Remove extra spaces first
LMN456789 =LEFT(A2,4), =RIGHT(A2,3), Extract first, last, middle
=MID(A2,4,3)
102 Maple Blvd =SUBSTITUTE(A2,“Blvd”,“Boule Replace abbreviation
vard”)
XY12345 =LEFT(A2,2)&RIGHT(A2,2) Create short code
Sec
tio
n A (Input) B (Output / Formula) C (Additional Exercise / Formula)
Alice Mary =LEFT(A2,1)&MID(A2,FIND(” Extract initials
Johnson “,A2)+1,1)&RIGHT(A2,1)
financial analyst =UPPER(A2), =LOWER(A2) Convert to upper and lower case
” excel master =TRIM(A2) Remove extra spaces
class ”
tomorrow =SUBSTITUTE(A2,“o”,“0”,2) Replace only second occurrence of
‘o’

You might also like