EXCELlent Ones Consulting Skip to Content Skip to Search

Print  |   | Download PDF


While this may sound like someone’s first name it’s also a function within Microsoft Excel. This function counts the number of characters in a string of text. Keep in mind that spaces count as characters as well. This function can be used to clean up data if used in conjunction with a few others.

1. Above are three examples of characters entered in cells.

2. The syntax for the function is =LEN (Cell_Address)

3. The function reveals the number of characters for each example


Email: info@excellentones.com | P.O. Box 160493 | Brooklyn, NY 11216 | Phone: (347) 763-1035 | Fax: (718) 228-7859

All rights reserved. Copyright 2014 Excellent Ones Consulting LLC.