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)
  • Privacy Policy
  • Terms of Use
  • Disclaimer
  • 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

What Does It Mean to Have a Sense of Urgency?

What Exactly Do Consultants Do?

Why Consultants Hate Their Clients But Keep Coming Back For More

How to Get Into Business School – Part 3 (Interviews)

How to Get Into Business School – Part 1 (GMAT)

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

  • How To Customize A LinkedIn Invite From Your Phone
  • Weird non-flex but ok
  • The little video game that could is putting on a masterclass in marketing yourself by picking a fight with two juggernauts
  • Today’s message is brought to you by middle of the night confusion
  • This. Is. Sparta!
  • Privacy Policy
  • Terms of Use
  • Disclaimer

© 2012–2021 Eric P. Butts