Eric P. Butts

THE Career Site for Accountants and Consultants.

  • Home
  • About
  • Useful Resources
  • Articles
  • Work With Me
    • Breakthrough Resume Writing
    • How to Get Smart in Excel…Fast!
    • Corporate Ladder University (Book)
  • Login
You are here: Home / Excel / How to Count Characters in a Cell in Excel

November 6, 2016 by Eric Butts Leave a Comment

How to Count Characters in a Cell in Excel

How to use the Len Formula

Have you ever needed to know how many characters were in a cell?

It sounds a little ridiculous but I found myself in that exact position a couple of weeks ago.

I had an Excel template that we needed to use to upload some information that was originally created in a separate workbook. Unfortunately there were two issues. First, the template required a max of 255 characters in one of the fields. Second, the template didn’t tell you which rows were over the limit.

Enter the len formula. It’s often overlooked but it saved the day that day.

The way you use it is simple. Let’s say you receive an error message that says “There is a maximum of 255 characters for description.” All you do is go back to your Excel file and add another column. Type in =len(CellReference) and press enter. You fill down to all the rows and then filter on the ones above the cutoff.

You modify the ones that show up and watch the len formula result decrease as you rework your cell content. Once they’re all below your limit, go ahead and try to upload again or re-submit your file as needed.

Simple yet satisfying.

If the gif image above moves a little too quickly or you just want to have the video version sent to you, click the button below.

Click Here to Have the Len Formula Video Sent to You

Filed Under: Excel Tagged With: excel formulas

About Eric Butts

I’m a management consultant, MBA and CPA who has a passion for helping others in their career pursuits. Grab my FREE cheatsheet on 12 simple habits of highly successful consultants.

Leave a Reply Cancel reply

You must be logged in to post a comment.

Featured Posts

Motivating Employees: Take The Time to Meet Your People

Watch Out For The Bobblehead Manager

How Bad Can It Hurt To Say Thank You?

What Exactly Do Consultants Do?

What Does It Mean to Have a Sense of Urgency?

Popular Posts

  • 5 Reasons You Should Be Proud to Ask Dumb Questions at Work
  • What Does It Mean to Have a Sense of Urgency
  • Always Stay Close to the Gatekeepers
  • Why Are There Still So Few Black CPAs?
  • What's the Difference Between FP&A and Accounting?
  • 3 Reasons Average Students Become Good Accountants
  • One Thing You Should Never Do on Linkedin
  • How to Handle Double Standards in the Workplace
  • How to Pass the CPA Exam Without Breaking the Bank
  • Masters in Accounting Isn't The Sweet Treat Some Students Think

Recent Posts

  • The 3 word Facebook post that has me feeling all kinds of motivated right now
  • I think I discovered the last fax machine this weekend (and a related lesson you should be immediately applying)
  • How to create your own luck in your career
  • Here’s why you may want to rethink that skills section on your resume
  • Internet troll triggered by a pair of tweets
  • Privacy Policy
  • Terms of Use
  • Disclaimer

© 2012–2021 Eric P. Butts