How to Count characters in Excel

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:
Video created with iMovie:
Song created with GarageBand:
Screen recording done with QuickTime Player:


Xem thêm bài viết khác:

Leave a Reply

Your email address will not be published. Required fields are marked *