Getting the longest lengh in range of cells

G

Geoff

I am trying to get the length of the longest cell in a range and use the
array {=len(a1:a1)}. What happens is that it picks up the length of cell A1.
Is there a way in a formula to determine the longest cell length in a range,
or through VBA.

Thanks in advance
 
P

papou

Hi
Try this formula array (please amend with last row number):
{=MAX(LEN(A1:A7))}

HTH
Cordially
Pascal
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

return cell address of longest text string in a range 2
Witch is the longest text in a column 6
Column Width Adjustment 3
Macro DoSomething in every cell of my selected range 1
Cannot paste named range formula 3
Sumif with named range of nonadjacent cells. 6
Mutiply in a range of cells ? 1
Excel VBA 1

Top