Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 230
  • Last Modified:

How count maximum character could in a row

In an Excel file I need to count the maximum character count in each row.  In other words, say column A has the following data in the cells:

Horse
Dog
Cat

Then the answer for that row is 5.

How can this be done?
0
SteveL13
Asked:
SteveL13
  • 2
  • 2
1 Solution
 
unknown_routineCommented:
How many cells are in each row? one?
0
 
unknown_routineCommented:
You can use EXcel's Len Function

for example =LEN(A1)
0
 
SteveL13Author Commented:
I wrote the question wrong.  I'm trying to get the maximum character count in a column, not a row.

I tried:

=(LEN(B3:B2915))

But it didn't work.
0
 
NBVCCommented:
Try:

=MAX(INDEX(LEN(B3:B2915),0))
0
 
SteveL13Author Commented:
Perfect.  Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now