Removing words which are not first name

[draxz]

I had posted in the formulas section, but wasnt sure if this is the right section..

Hello,

I have a data set of 320,000 with first and last name columns, some of the names are not names for example first name is Subway and last name is Restaurants instead of Joe Smith

I am looking for a way to remove the data in the first and last name columns which is not a name also which have numbers.

Any help is appreciated.

[FDibbins]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.

http://www.excelforum.com/excel-form...irst-name.html