Question about the longest cell in excel

Not applicable

Hi! I have an excel file which has nearly 30000 observations and 45 variables and I would like to find out the longest cell in each column. I know how I can get the longest cell in a specific column. I use the formula as the following below. Is there a single formula that allows me to get the longest cells in each column (for each variable) so that I do not need to put that formula for 45 times. Thanks in advance! 


Formula I am using:


0 Replies