How do I remove the leading 1 from a nine digit telephone #

[Guest]

How do I remove the leading 1 from a nine digit telephone #'s stored in a
column in excel. Eg. Get 17035551212 to be 7035551212

 

[JulieD]

Hi

one option is to use a "helper" column e.g. if your numbers are in column A,
starting on row 1 in B1 type
=right(A1,len(A1)-1)
(as your phone numbers in the example don't appear to be 9 digits long)
then move the cursor over the bottom right of cell B1 and when you see a +
double click this will fill the formula down the column. When you're happy
with the result select column B and choose copy
click on A1 and choose edit / paste special - values to replace the
information in column A and then delete column B

Hope this helps
Cheers
JulieD

 

[Dave Peterson]

Another way:

Put 10000000000 (with commas for easier reading: 10,000,000,000)
in an empty cell.
copy that cell
select your range of 10 digit phone numbers
edit|paste special|select the Subtract option.
Clean up that helper cell.