Deleting cells based on number of characters in a word

Hi, I have spreadsheets in which I need to remove any rows that contain words with less than three characters (letters or numbers) in one specific column. In other words, if the first column of my spreadsheet contains A1, or ft, or 45 as separate words. (random examples) that row would be removed.

I'm not yet familiar with how to create and implement that type of find and replace function so I need specific and detailed instructions. Thanks so much.

One way would be using a macro like this:

Please Login or Register  to view this content.

This macro assumes that you checks the cells in column A. If it's column C you whish to chech change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Alf

Wow! thanks.

I pasted the code into the visual basic macro page, selected my spreadsheet and ran the macro and...nothing happened. I wish I knew more about this but I don't write visual basic so I'm no help to myself. Any thoughts?

Hi

How about attaching an example workbook. One other thing to check is that your cell actually only contains 2 character words, and not say, 2 chars with a third that is a space.

rylo

No, the original worksheet has 4000 entries. I had to shorten it to meet the file size requirements for uploading to the forum. Most of the offending entries are at the beginning of the file. The concept will work for me. I just don't know how to do it. Thanks

Hi

OK, I've edited my post with some code. See how that goes.

rylo

No, the original worksheet has 4000 entries. I had to shorten it to meet the file size requirements for uploading to the forum. The concept will work for me. I just don't know how to do it. Thanks

Awesome, that worked perfectly. I sure do appreciate you taking the time to pop that out for me. Perfect.