Filtering Data

[bowl]

I have 2 columns and I need to filter out data that doesn't meet my criteria. I need my data on column B to be BOTH alpha AND numeric. So it must contain BOTH letters and numbers ONLY, and it must also be a minimum length of 7 characters.
Example...
A B
abc 123456A
1fgh abcdefg813
jkl abcdefghi
7626 $837ghijkl
abcbc 123abc

All that should remain are...
A B
abas 123456A
1fgh abcdefg813

Thank you in advance.

[dilipandey]

Hi Bowl,

Welcome to the forum.
Apart from letters and numbers, what other characters column B can have... like one I found as "$".. is there any more ? Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[Jakobshavn]

Hi Bowl:

Hi-light the cells in column B you wish to filter and run the FilterJunk macro:

Please Login or Register  to view this content.

Macros are very easy to install and use:

1. ALT-F11 brings up the VBE window
2. ALT-I

ALT-M opens a fresh module

3. paste the stuff in and close the VBE window

If you save the workbook, the macro will be saved with it.

To remove the macro:

1. bring up the VBE window as above
2. clear the code out
3. close the VBE window

To use the macro from Excel:

1. ALT-F8
2. Select the macro
3. Touch RUN

To learn more about macros in general, see:

http://www.mvps.org/dmcritchie/excel/getstarted.htm

Macros must be enabled for this to work!

[bowl]

RE RE EDIT: I got it working and it is almost perfect but... It filters out data that doesn't have a least 1 capital letter, which is not what I was looking for. I will try to fix it myself, while I wait for a response from you guys. Thanks