How can I filter cells that contain two or more strings like this 800-361-4827?

[JeanExcel]

I have several cells with only one phone number. How can I filter those which have more than one cell phone? For example, I want to find cells like this:


MCCLANAHA Juan `RR I Box 1488 Alton 778-6076; Mcdonald S `1820 N Main St 417-926-4747

The amount of numbers in the phone number may vary.

Thanks in advance for your help.

 

[boatbabe]

Will the phone numbers always have hypens and if so could any other part of the string contain a hyphen? if yes and no respectively search by hyphen?

OR

Will the phone number always be at the end of the string? If so use Right and select the max number of characters the phone number could contain, then remove any text?