Fix messy names with PROPER and TRIM

Premium

The name in A2 has extra spaces and the wrong capitals. In B2, clean it up to "Maria Lopez". Put TRIM inside PROPER.

B2
ABCDEF
1Name as typed Name
2 mARIA lOPEZ
3
4
5
6
7
8

Premium lesson

Unlock TRIM, PROPER and UPPER and every other lesson

This is a premium lesson. Premium lets you solve it and every other lesson, take the timed mock tests, and earn certificates you can share on LinkedIn.

Next with premium:LEFT, RIGHT and MIDFIND and SEARCH

Your first month for $9.50 $19

50% off your first month when you join today.

Get your first month for $9.50

Then $19/month. Cancel any time, and get a full refund within 14 days if it isn't for you.

Already premium? Sign in
Need help?