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?
SteveL13Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
NBVCConnect With a Mentor Commented:
Try:

=MAX(INDEX(LEN(B3:B2915),0))
0
 
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
 
SteveL13Author Commented:
Perfect.  Thanks!
0
All Courses

From novice to tech pro — start learning today.