I would like to identify cells in a column that have more
then a certain number of characters in them because I need
to trim them down so fit on a mail merge lable.

We can go with color coding - which would be great or in
required I can have a new field that an x appears when my
target field has to many characters in it.

The color coding of the cell would be great.

Thanks Todd

Todd,

conditional formatting.

Use a condition of IsFormula, and a formula of =LEN(A1)6, and just choose a
format to suit. This assumes A1 is the first cell you want to format, and
the length you want is 6.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Todd" wrote in message
...
I would like to identify cells in a column that have more
then a certain number of characters in them because I need
to trim them down so fit on a mail merge lable.

We can go with color coding - which would be great or in
required I can have a new field that an x appears when my
target field has to many characters in it.

The color coding of the cell would be great.

Thanks Todd

Thank you
-----Original Message-----
Todd,

conditional formatting.

Use a condition of IsFormula, and a formula of =LEN(A1)
6, and just choose a
format to suit. This assumes A1 is the first cell you
want to format, and
the length you want is 6.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Todd" wrote in
message
...
I would like to identify cells in a column that have
more
then a certain number of characters in them because I
need
to trim them down so fit on a mail merge lable.

We can go with color coding - which would be great or in
required I can have a new field that an x appears when
my
target field has to many characters in it.

The color coding of the cell would be great.

Thanks Todd


.