Need to format telephone numbers into 10 digit number only.

[tamwink]

How do I remove the country codes, hyphens, and "+1" from a column of data?
All information appreciated.

 

[Fluff]

With a formula

Book1
	A	B	C	D	E
1	CITY	STATE		PHONE
2	Whiting	NJ		‭+1 (704) 806-3506	7048063506
3	Kendall Park	NJ		024 0608 8588	2406088588
4	Kendall Park	NJ		030 377 1554	303771554
5	Kendall Park	NJ		06-687 5888	66875888
6	Kendall Park	NJ		0757 7192169	7577192169
7	Lakewood	NJ		08503 810221	8503810221
8	Lakewood	NJ		0910 830 3999	9108303999
9	Lakewood	NJ		0917 535 9028	9175359028
10	Lakewood	NJ		0929 035 6104	9290356104
11	Whiting	NJ		095 935 6565	959356565
12	Whiting	NJ		1 512 473-2305	5124732305
13	Whiting	NJ		1 585-258-3696	5852583696
14	Whiting	NJ		1-(626) 539-0548	6265390548
15	Beaufort	SC		p:+1(602) 7054282	6027054282
16	Allendale	SC		p:+1(612) 750-9273	6127509273
17	Sumter	SC		p:+1(770) 362-2000	7703622000
18	Atlanta	GA		p:+1(979) 665-5052	9796655052
19	Atlanta	GA		p:+117579209003	7579209003
20	Atlanta	GA		p:+118014727251	8014727251
21	Salt Lake City	UT		954 793-1073	9547931073
22	Salt Lake City	UT		954 805-0608	9548050608
23	West Valley City	UT		954 805-6295	9548056295
24	Draper	UT		954 805-7107	9548057107
25	s.l.c.	UT		954 812-9849	9548129849
26	Salt Lake City	UT		954 815-4878	9548154878
27	Vernal	UT		954 815-5773	9548155773
28	Salt Lake City	UT		954 817-7959	9548177959
29	Salt Lake City	UT		954 821-3795	9548213795
30	Bountiful	UT		954 821-4484	9548214484
Mon

Cell Formulas
Range	Formula
E2:E30	E2	=RIGHT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(D2,",",""),"-",""),"(",""),")","")," ",""),10)

 

[tamwink]

Thank you all for your assistance.

 

[Fluff]

Glad we could help & thanks for the feedback

 

[shg]

You could instead select the column and use find and replace ...