Finding max length of cell contents across a table

[Lucubrare]

I have a problem importing excel data to Access, and I can't find find why. The error I get when I try to import is "Subscript out of range." I suspect that one (or more) of the cells in my table is greater than 255 and trying to fit into a text (as opposed to memo) field, which is limited to 255 characters. This table is several thousand rows long, and about 45 columns wide.

What I'm trying to do is find a formula combination that would read the length of all cells in a column and return the length of the longest cell.

Thank you in advance for the help.

[shg]

=max(len(a1:a1000)), committed with Ctrl+Shift+Enter.

[Lucubrare]

This indeed met the need. I had tried with combinations of Max and Length, but apparently did not get the correct syntax.

Thank you very much.