How to extract phone number from multi-line strings in cells in excel-CodePudding

Example of cells below. As you can see some cells have more info like emails, and some don't have a number but they're all in the same column.

Cell 1

Smith, James W
#129432
123 N. Street Road
 Libertyville, IL, 60048
(810) 955-9721 
[email protected]

Cell 2

Evette T Rudnick
#7928253
1308 Stutler Lane
Tidioute, PA, 16351

Cell 3

David C Ponce
#1234567
2855 Retreat Avenue
 Frenchboro, ME, 04635
(313) 204-6364

Any help is appreciated. Thank you.

CodePudding user response：

Use MID and SEARCH:

=IFERROR(MID(A1,SEARCH("(???) ???-????",A1),14),"")