Contacts Not Showing On Incoming Call - Help

[Yisroel Tech]

I'm asking in my case. Which command will take out the 1s?

Oh. I've already posted that:

I'd do outlook CSV.

Then open in Google Sheets (or open in Excel and select all and C/P to Google Sheets.

In Google Sheets make a Find and Replace from 1\d{10} to $1

Then save back as CSV and import in Google (delete first all the contacts there).

[ilherman]

Oh. I've already posted that:

Some contacts still showing the 1 I guess because they are stored with a plus + before the 1 and need to be removed differently?

[Yisroel Tech]

Some contacts still showing the 1 I guess because they are stored with a plus + before the 1 and need to be removed differently?

Search for \+1(\d{10}) and replace with $1. But make sure "Also search within formulas" is checked.

[Yisroel Tech]

Search for \+1(\d{10}) and replace with $1. But make sure "Also search within formulas" is checked.

This is good if all numbers are in the format of 1xxxxxxxxxx or +1xxxxxxxxxx but there were all kind of numbers with parentheses dashes and spaces... What I ended up with was replacing these:
\+1(\d{10})$
1(\d{10})$
With $1.
And these:
1-(\d{3})-(\d{3})-(\d{4})
(\d{3})-(\d{3})-(\d{4})
1 (\d{3})-(\d{3})-(\d{4})
\((\d{3})\) (\d{3})-(\d{4})
\+1 (\d{3})-(\d{3})-(\d{4})
\+1 \((\d{3})\) (\d{3})-(\d{4})
1(\d{3}) (\d{3}) (\d{4})
(\d{3}) (\d{3}) (\d{4})
With $1$2$3

[myi]

d stands for digits? While 10 being 10 digits?
Wonder if I could do the same thing by adding a +(plus) and a 1 in front of all my phone numbers in my contacts, would make it a lot eaiser to place phone calls while using Google hangouts or Google Voice( as all u.s. and Canadian numbers need to have the plus sign and the number one before dialing.)
  If it doesn't have a plus and and a 1 in front of the number I have to remember the 10 digit number and plug it in manually to call.
  What coding would I use to change all my numbers to a 1 and+? Thanks

Yes, \d is digits and {10} is a quantifier for the thing it is after.

You would replace (\d{10}) with +1$1:

This is good if all numbers are in the format of 1xxxxxxxxxx or +1xxxxxxxxxx but there were all kind of numbers with parentheses dashes and spaces... What I ended up with was replacing these:
\+1(\d{10})$
1(\d{10})$
With $1.
And these:
1-(\d{3})-(\d{3})-(\d{4})
(\d{3})-(\d{3})-(\d{4})
1 (\d{3})-(\d{3})-(\d{4})
\((\d{3})\) (\d{3})-(\d{4})
\+1 (\d{3})-(\d{3})-(\d{4})
\+1 \((\d{3})\) (\d{3})-(\d{4})
1(\d{3}) (\d{3}) (\d{4})
(\d{3}) (\d{3}) (\d{4})
With $1$2$3

Assuming I would use +1$1+1$2+1$3.
 Will try this as soon as I get near a computer.
Thanks yt?.

  Curious how would I avoid changing numbers which start with 05..
 Meaning don't want to change any Israeli numbers?

[talmid chuchem]

This is good if all numbers are in the format of 1xxxxxxxxxx or +1xxxxxxxxxx but there were all kind of numbers with parentheses dashes and spaces... What I ended up with was replacing these:
\+1(\d{10})$
1(\d{10})$
With $1.
And these:
1-(\d{3})-(\d{3})-(\d{4})
(\d{3})-(\d{3})-(\d{4})
1 (\d{3})-(\d{3})-(\d{4})
\((\d{3})\) (\d{3})-(\d{4})
\+1 (\d{3})-(\d{3})-(\d{4})
\+1 \((\d{3})\) (\d{3})-(\d{4})
1(\d{3}) (\d{3}) (\d{4})
(\d{3}) (\d{3}) (\d{4})
With $1$2$3

Wouldn't changing the format of the column to telephone number format solve the problem that they are in different formats?