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
claudie.predov@hotmail.com
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.
Solution
Use MID and SEARCH:
=IFERROR(MID(A1,SEARCH("(???) ???-????",A1),14),"")
- How to use a variable to globally define a cell's location?
- "Interface not supported" error when attempting to open Excel or Word from Delphi
- Generate a summary table in Excel for multiple variables without PivotTable
- Array formula on Excel for Mac
- openpyxl: (column) grouping - outline level not working & retaining only last one
- Optimization using Solver in Excel
- Runtime error 5020: Replace content in cells based on contents of a different cell (using regex patterns)
- Excel SUM function is not working (shows 0), but using Addition (+) works
- Export charts from excel to image
- VBA to delete unused named ranges in Excel
- SQL Server export to Excel with OPENROWSET
- Excel - Get hourly averages for data spanning 1 year (8760 data points)
- How to round time to nearest hour in Excel?
- Excel to XML code in java?
- Date difference with VBA InputBox in "Years" "Months" "Days" format
- Extract Certain Text from excel
- excel vba getting the row,cell value from selection.address
- Need help editing VBA to pull from a specific subfolder versus all subfolders
- How to temporarily turn off Conditional Formatting rules in Excel for only selected cells
- Excel FILTER with dynamic conditions
- Problem with ActiveSheet.Paste Link:=True
- Is there a way to extract the text from a cell by referencing the cell?
- Authorization issue while trying to connect to Azure DevOps REST API with MS Excel VBA
- VBA hyperlink replace function out of memory
- A non-VBA recursive factorial function?
- Simple recursive function in VBA with Excel not returning expected result
- Excel VBA attach multiple worksheets in one email
- How can I create a replay loop from different cells?
- Convert an excel or spreadsheet column letter to its number in Pythonic fashion
- Need an excel VBA code to determine whether or not a cell contains an embedded picture