CODEWITHSUNDEEP
excel
aalhayekahmc
aalhayekahmc

Reputation: 33

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

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.

Upvotes: 1

Views: 1259

Answers (1)

Scott Craner
Scott Craner

Reputation: 152525

Use MID and SEARCH:

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

enter image description here

Upvotes: 2

Related Questions