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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

thanks!
 
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!
 
Trying to get a 1 to prefix phone numbers in an existing column with
thousands of entries.

thanks!
Click to expand...

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word Create a Phone Book using MailMerge in word 2007 0
how to display zero prefixes in worksheet cells such as phone numb 1
Format phone numbers to look the same 1
Checking if data exists another table and, if yes, extracting a value 0
Merging data from 3 columns 2
Copying Data from 1 format to another 1
Phone Number Excel 2003 7
function for search 2

Back
Top