Hi kb

=LEN(C1)
will return the number of characters in C1.
If you copy that down in Column D you can serch that.
OR
=if(LEN(C1)=11,LEFT(C1,10),C1&if(LEN(C1)<9," ","")&if(LEN(C1)<10,"
",""))
will remove the last character if the text is 11 characters or add
spaces up to 10 characters if less than 10 characters (but only within
your 8 to 11 character parameters)

Bob

On Fri, 6 May 2005 12:32:01 -0700, "kb_63"
wrote:

I have a large worksheet, which the data was imported. In column C of the
worksheet the text ranges from 8 characters to 11 characters in length. I
need to have all the text in column C to be 10 characters long. Is there a
way to search column C for all cells that don't equal 10 characters long? I
would also like it to stop at each cell that doesn't equal 10 characters so I
can correct the cell. Somewhat like a find and replace. Thank You for your
time.