delete anything in colum "A" with more than 4 letters

As the title suggests, I need a macro that will automatically look at colum A (except range A1) and then delete anything that is not alphabet letters i.e. a * or other charecters. Also need to delete if more than 4 letters long.

Can you help?

Thanks in advance

try this for delate string longer then 4 characters

Please Login or Register  to view this content.

ollierice

Do you mean just keep cells with one to four letters only?

Please Login or Register  to view this content.

or remove numbers and symbols?

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save