Format a Phone Number

after removing the space you could also format the number to just show the leading 1 without actually storing it in the number. Use custom format

1#

Or for a formula approach

=text(a1,"1#")

format the number to just show the leading 1

Don't think the 1 will export to Access if you do that ...

Or for a formula approach
=text(a1,"1#")

Might export as Text to Access if you do that ...