Select Multiple Cells at one time based on the lenght of the cell content

In Excel conditional formatting we are able to highlight the cells based on the length of the cell content. But what i am looking for is, whether we can select multiple cells on one time based on the length of the CELL CONTENT.

Thanks.

Thanks for your reply. But I am sorry, I forget to make it a point, that what I am expecting is without using LOOP; Since when I a code with a loop like this in a excel document which contains 5K+ rows of data, the performance of excel will be least. In my current scenario I have used Loop only to achieve this but trying to OPTIMIZE the code to improve performance.

Any kind of help is much appreciated. Thanks in advance.

See the definition of the FindAll function located on this page.

You can use this function like this

Please Login or Register  to view this content.

to select all cells with a length >= 2. Use a "?" for each required character. It uses Find and therefore will give you better performance than a For loop. I have tested it but it's not my code so I don't support it.