Link to home
Start Free TrialLog in
Avatar of SteveL13
SteveL13Flag for United States of America

asked on

Maximum character count in a column

Is there a way to get the MAXIMUM character count of any cell in a column?  In other words if the worksheet looked like this...  The result would be:

User generated image
Avatar of strivoli
strivoli
Flag of Italy image

Create a Column on the right of each one with length(cell), last cell is max(cells).
Avatar of SteveL13

ASKER

I don't understand.
I'll be back with an example in 10 minutes.

Hopefully, you can extrapolate what the other cells should be:

User generated image

Column D is the length of A, Column E is the length of B, Column F is the length of C.  "cell" represents the cell reference - a1, a2, b3, c2, etc)

SOLUTION
Avatar of Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj)
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I’m glad I was able to help.

If you expand the “Full Biography" section of my profile you’ll find links to some articles I’ve written that may interest you.

Marty - Microsoft MVP 2009 to 2017
              Experts Exchange Most Valuable Expert (MVE) 2015, 2017
              Experts Exchange Top Expert Visual Basic Classic 2012 to 2019
              Experts Exchange Top Expert VBA 2018, 2019
              Experts Exchange Distinguished Expert in Excel 2018