40 characters in title.

excel function?

[glittergrrrrl]

is there an excel function so that i can limit 40 characters per cell?

[mike_ppc]

you can use the len function to see nb of chars. You can add an if to see some kind of warning.

[glittergrrrrl]

thanks a lot

[BillyS]

You can also use the LEFT function - =LEFT(Text, Number of Characters).

[BillyS]

Here is a second way...

Data, Validation, Allow, Text Length, Minimum 0, Maximum 40.

This particular feature will prevent people from entering more than 40 characters in a cell.

That's $2 please.