how extract phone number from middle of the text

What result are you expecting from the second example "Denver Colorado...." ?
There are three potential numbers

This will extract the number if the phrase "Phone" is found in the data

=IF(ISNUMBER(FIND("Phone",A1)),MID(A1,FIND("Phone",A1)+7,12),"")

I don't know where your records start or end but there are when I copied your examples into Excel rows that had multiple telephone numbers. This formula will extract the first telephone number in each row excluding extension numbers but not any of the other telephone numbers. A further clarification of the data format would be appreciated to facilitate giving a better solution. For example: are there really multiple telephone numbers in a row like appears in your example row 2?

The first part of this formula is nearly identical to that of Special-K and works the same except I used Search instead of Find. SEARCH is not case sensitive while FIND is case sensitive. This isn't a consideration when finding numbers as there isn't an upper or lower case number.

Formula:

Please Login or Register  to view this content.

The formula that I gave can be shortened to the following which finds the starting point of the first number in the text string and returns 12 values. This of course will not work if there is some other number before the telephone number if a telephone number isn't found with "phone" preceding it:

Formula:

Please Login or Register  to view this content.