How to sort cells in a column that contain the pattern XXX-XXX-XXXX

[rlouderback]

I have a long list of contact information that I'd like to sort by ones that have a phone number in the name column. An example:

Bob Johnson
Joe WALMART
John Smith 555-555-5555

There are numerous entries but I'm trying to sort a column so I can group the entries that have a phone number like John Smith's does above. Not all cells contain names, some contain company names or any random nouns, but the cells with phone numbers are all in the 555-555-5555 format.
Thanks for any help.

 

[Special-K99]

Is the phone number ALWAYS the last part of the cell or could it appear anywhere?

 

[rlouderback]

50 out of 11,000 entries are in a different format, but the rest of the cells with phone numbers will have them as the last part of the cell. Once I figure out how to group them, I'll be using the RIGHT formula to send the phone numbers to the cells I want them in.