From the course: Excel Formulas and Functions Quick Tips
Join today to access over 24,700 courses taught by industry experts.
Count characters with LEN - Microsoft Excel Tutorial
From the course: Excel Formulas and Functions Quick Tips
Count characters with LEN
- [Instructor] The LEN function counts characters within a text string. Let's find out how many characters are in this email address. Equal sign LEN, open parentheses. Put the text or cell reference that you want to count the characters in and then close the parentheses. There's 24 characters in this email address. LEN counts letters, numbers, special characters and spaces. There's 118 characters in this paragraph. LEN is commonly used with other functions. Let's use it with if. If the length of cell A2 is greater than or equal to 78 I'll put OK, otherwise something else.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
Contents
-
-
-
-
-
-
(Locked)
Format numbers and dates with TEXT2m 4s
-
(Locked)
Extract characters with LEFT AND RIGHT1m 20s
-
(Locked)
Extract substrings with MID56s
-
(Locked)
Count characters with LEN1m 7s
-
(Locked)
Identify where a character occurs with FIND1m 59s
-
(Locked)
Join strings with delimiters with TEXTJOIN1m 48s
-
(Locked)
Change text with SUBSTITUTE and REPLACE1m 55s
-
(Locked)
-
-
-