How to add a 1 to existing column of phone numbers?

[Jan]

Trying to get a 1 to prefix phone numbers in an existing column with
thousands of entries.

thanks!

 

[jabax]

hi jan,

surf to www.asap-utilities.com and download the wonderful free utility
featured there. your problem will be answered with this utility

yves

 

[RagDyeR]

What exactly do you presently have in the list now?

If, for example, you had:
(213) 123-4567

You could use "Edit & Replace", where you "Find"
" ( " (no quotes)
And replace with " 1 ( " (no quotes).
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Trying to get a 1 to prefix phone numbers in an existing column with
thousands of entries.

thanks!

 

[Ron Rosenfeld]

Trying to get a 1 to prefix phone numbers in an existing column with
thousands of entries.

thanks!

If your phone number is A1 and is in US format, then, if you want ALL numbers
to be prefixed by a 1:

=TEXT(A1,"[<=9999999]1-###-####;1-(###) ###-####")

If you only want those numbers with area codes prefixed by a 1, then:

=TEXT(A1,"[<=9999999]###-####;1-(###) ###-####")


--ron