Be a genius with Excel in this tutorial of How to count characters in Microsoft Excel. Easy formula, easy drag formula repeat function.

To count the characters for a text string in Microsoft Excel, we’re going to show you how to use LEN and CHR

Formula explained:
LEN: Means that the formula returns the number of characters in a text string formula syntax.
CHR: Returns the character based on the ASCII value
&: Because it connects two values

Step 1: Select the cell in which you’d like the characters to display
Step 2: Type in /”=LEN(/”
Step 3: Select the cell that you’d like to count characters for
Step 4: Type /”& /”Chr/”
Step 5: Hit enter!

So your formula will look something like this:

=LEN(B3) & /”Chr/”

Be sure to pop us a comment, or visit the Facebook Help centre for more.

Thank you for watching /”How to create a Facebook Page/”. Any ideas on what to watch, or how our videos can improve, please leave a comment.

—Proudly South African—

Please subscribe for weekly episodes.

Thumbnail created with Adobe Spark: https://spark.adobe.com
Video created with iMovie: http://www.apple.com/mac/imovie/
Song created with GarageBand: http://www.apple.com/mac/garageband/
Screen recording done with QuickTime Player: http://quicktime-download.info/

Please take the opportunity to connect and share this video with your friends and family if you find it useful.