Get max characters in cell in 1 column
I am trying to figure out how to get the max charcters in a column. So if I have ten items in one column, I want to be able to put a formula or run a macro that will count the total number of characters in each cell and then return the max number. thanks in advance. -- fbonilla ------------------------------------------------------------------------ fbonilla's Profile: http://www.excelforum.com/member.php...o&userid=32011 View this thread: http://www.excelforum.com/showthread...hreadid=517528 |
Get max characters in cell in 1 column
=MAX(LEN(A1:A100))
which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "fbonilla" wrote in message ... I am trying to figure out how to get the max charcters in a column. So if I have ten items in one column, I want to be able to put a formula or run a macro that will count the total number of characters in each cell and then return the max number. thanks in advance. -- fbonilla ------------------------------------------------------------------------ fbonilla's Profile: http://www.excelforum.com/member.php...o&userid=32011 View this thread: http://www.excelforum.com/showthread...hreadid=517528 |
Get max characters in cell in 1 column
try =Len(B3) =len("abc") regards -- tony h ------------------------------------------------------------------------ tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074 View this thread: http://www.excelforum.com/showthread...hreadid=517528 |
Get max characters in cell in 1 column
=MAX(LEN(A1:A20))
This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it correctly, excel will wrap curly brackets {} around your formula. (don't type them yourself.) Adjust the range to match--but you can't use the whole column. fbonilla wrote: I am trying to figure out how to get the max charcters in a column. So if I have ten items in one column, I want to be able to put a formula or run a macro that will count the total number of characters in each cell and then return the max number. thanks in advance. -- fbonilla ------------------------------------------------------------------------ fbonilla's Profile: http://www.excelforum.com/member.php...o&userid=32011 View this thread: http://www.excelforum.com/showthread...hreadid=517528 -- Dave Peterson |
All times are GMT +1. The time now is 03:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com