On Mon, 27 Oct 2008 21:17:56 +0100, "Joergen Bondesen"
wrote:

Hi NG.

I have a spreadsheet with 7 columns and 150000 rows.

For each column i want to know max. character include spaces.

I can test all cells, one by one per column, but I need at faster way.

Any suggestion?

Try the following formula to get the max number of characters in
column A from line 1 to 150000

=MAX(LEN(A1:A150000))

Note: The formula must be entered as an array formula, i.e. with
CRTL+SHIFT+ENTER rather than just ENTER.

Hope this helps / Lars-Åke