Forum Moderators: open

Message Too Old, No Replies

40 characters in title.

excel function?

         

glittergrrrrl

8:17 am on Nov 28, 2006 (gmt 0)

10+ Year Member



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

mike_ppc

12:06 pm on Nov 28, 2006 (gmt 0)

10+ Year Member



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

glittergrrrrl

2:02 am on Nov 29, 2006 (gmt 0)

10+ Year Member



thanks a lot

BillyS

2:16 am on Nov 29, 2006 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



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

BillyS

2:21 am on Nov 29, 2006 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



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.