Searching & Extracting Information

[Zavior]

I'm having troubles writing a formula that will do what I want it to. I have around 8000 rows of single column information. The Fields contain a number, between 1-4 digits long in the beginning. Then they contain a name and sometimes a number at the end of the last name, which is either 1,2,3 or 4. What I'm trying to do is delete all the rows that do not contain that number in between the name.

Example:

A1790: 1787 SPEARS, BRITNEY
A1791: 1788 JACKSON, ALLEN
A1792: 1789 JOHNSON 4, JACK
A1793: 1790 JOHNSON 1, MAGIC

I want the function to delete rows A1790 & A1791 because they do not have a number at the end of the last name.

How would I go about doing this?

[Shijesh Kumar]

try this code...
Assumption made :
name is in column B

Please Login or Register  to view this content.

[Zavior]

Shijesh,

First off thank you for the quick reply. Your function works, but it does the opposite of what I'm looking for. Your function currently deletes all the rows that have numbers at the end of the last name. I'm looking for it to delete all the rows that do not have numbers at the end of the last name. How would that function be modified to do so?

[Shijesh Kumar]

not a problem,

heres the code for that

Please Login or Register  to view this content.

[Zavior]

Shijesh,

I fixed the function to work as I wanted, I reversed the If function. Thank you for your help, your resolved my headache.