Hello,

I am attempting to filter a 60,000+ column of phone numbers, and all I am trying to do, is run a macro that removes the 1 at the start of any numbers that have it. some do, many do not have it.

example :

original value : 18005551212

desired value : 8005551212

Is their a fast way to do this?

I am kinda clueless where to start with a macro like this.

thanks in advance,

spyrule.