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


"pc" wrote in message
...
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