Text·Lesson 38 of 62Pro
How to use LEN in Google Sheets
Count characters
How LEN works
LEN counts the characters in text, spaces included.
LEN(text)
Example on this data
=LEN(C3)→12
Every SKU has the same length.
What you’ll do
You’ll count the characters in an email address. Checking length is a quick way to catch typos, blanks or values that are too long.
Try it
Type =LEN(C3) into G2 and press Enter. Watch what the sheet does.
The result will appear in G2.
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Full name | SKU | Note | ||||
| 2 | maria lopez | maria.lopez@acme.com | WID-2041-BLU | Call back 555-0142 | |||
| 3 | james chen | jchen@northwind.io | GAD-1180-RED | Sent invoice | |||
| 4 | Priya Shah | priya@shahdesign.co | WID-3307-GRN | Call back 555-0199 | |||
| 5 | tom o'neil | tom.oneil@acme.com | BOX-0042-BLU | Left voicemail | |||
| 6 | Lena Park | lena.park@globex.com | GAD-2215-BLK | Call back 555-0107 | |||
| 7 | sam reed | sreed@northwind.io | WID-0918-RED | Meeting Tue |
Ctrl+/ shows the shortcuts
Drill locked
Unlock the other 44 lessons for $49.99
You’ve seen how LEN works. Pro lets you write it yourself on real data and get checked instantly, with practice sets and section reviews for every lesson.
Your drill
In G2, count the characters in the email in B2.
One payment, no subscription.