I have a data feed that i need to fix really quick...here is the problem.

In one column the merchant inputted more than 30 characters in some cells. I need to remove the one with over 30 characters as we have a limit for this column. Is there a way that I can tell excel to sort them out, so that my life can be a lot easier to delete them?

Thank you very much first!!

 

Use LEN function. Look it up under help. Easy to use.

 

Thank you..I actually did a quick sort and it's a lot easier for me to delete.


I'll lock the thread now.