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:
Microsoft ExcelMicrosoft Office
Last Comment
Martin Liss
8/22/2022 - Mon
strivoli
Create a Column on the right of each one with length(cell), last cell is max(cells).
SteveL13
ASKER
I don't understand.
strivoli
I'll be back with an example in 10 minutes.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
strivoli
Lee W, MVP
Hopefully, you can extrapolate what the other cells should be:
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)
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.