I'm having a merging nightmare in excel ...

I'm trying to get rid of duplicates of names and address from a list
of about 6,000 however, the names and addresses are not uniformly
formatted (i.e. some have Apt. # in column Address 1 whereas some are
in column Address 2, some have AVE vs. Avenue, some names are Mr. and
Mrs. LastName others are FirstName and FirstName LastName. etc. etc.
the mess goes on).

Is there a formula I could put in a column next to the address line 1
just the street number followed by the first word? i.e. "111
Westbourne" from "111 Westbourne Terr. #3" I think that would help me
sort through the mess.

Is this the easiest way to go? Baaah....