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.