Do you mean the highest number of characters?
Try,
=MAX(LEN(A1:A100))
This is an array formula so commit with Ctrl-Shift-Enter not just
enter. It should look like this after commiting,
{=MAX(LEN(A1:A100))}
Does that help?
Steve
--
SteveG
------------------------------------------------------------------------
SteveG's Profile:
http://www.excelforum.com/member.php...fo&userid=7571
View this thread:
http://www.excelforum.com/showthread...hreadid=554539