Excel & Google Sheets lesson

PROPER, UPPER and LOWER

TRIM removes the spaces, then PROPER capitalises each word: Ada Obi.

About 5–10 minutes · no sign-up needed

Example

PROPER gives each word a capital first letter. Wrap it round TRIM to fix spaces and capitals at once:

=PROPER(TRIM(A2))

Typed into cell D2 of this sheet:

Name	City	Phone
ada obi	lagos	0803-555-1234
TUNDE BAKARE	ABUJA	0706-555-9876
grace eze	abuja	0812-555-4433
Musa Bello	Kano	0901-555-2211

PROPERCapital first letter on every word: ada obi becomes Ada Obi.

UPPER and LOWEREVERYTHING IN CAPITALS, or everything in small letters.

PROPER(TRIM(A2))Clean the spaces first, then the capitals.

Put together: =PROPER(TRIM(A2)). Codes like product IDs usually want UPPER.

Try each one in your head first, then open the answer.

1. In D3, give Tunde's name proper capitals.

=PROPER(A3)

2. In E4, write Grace's city in capitals.

=UPPER(B4)

3. In D4, tidy Grace's name: remove the spaces and fix the capitals.

=PROPER(TRIM(A4))

4. In E3, write Tunde's city in small letters, without the spaces.

=LOWER(TRIM(B3))

5. In E2, write Ada's city with a capital first letter, without the space.

=PROPER(TRIM(B2))

Learn it by doing. This lesson is a short hands-on level on Bampaa: see it work, then build and write it yourself, with instant feedback.

About 5–10 minutes · no sign-up needed