101. Counting Characters in a Cell

  1. John Walkenbach

Published Online: 11 NOV 2011

DOI: 10.1002/9781118257647.ch101

Book Title

John Walkenbach's Favorite Excel® 2010 Tips & Tricks

John Walkenbach's Favorite Excel® 2010 Tips & Tricks

Additional Information

How to Cite

Walkenbach, J. (2010) Counting Characters in a Cell, in John Walkenbach's Favorite Excel® 2010 Tips & Tricks, Wiley Publishing, Inc., Hoboken, NJ, USA. doi: 10.1002/9781118257647.ch101

Publication History

  1. Published Online: 11 NOV 2011
  2. Published Print: 28 JUN 2010

ISBN Information

Print ISBN: 9780470475379

Online ISBN: 9781118257647

SEARCH

CHAPTER TOOLS

Get PDF (109K)

Keywords:

  • cell;
  • len function;
  • counting characters;
  • formula;
  • number formatting

Summary

This chapter contains sections titled:

  • Counting all characters in a cell

  • Counting specific characters in a cell

  • Counting the occurrences of a substring in a cell

Get PDF (109K)