Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Jan
 
Posts: n/a
Default How to add a 1 to existing column of phone numbers?

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

thanks!

  #2   Report Post  
jabax
 
Posts: n/a
Default

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

"Jan" wrote:

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

thanks!

  #3   Report Post  
RagDyeR
 
Posts: n/a
Default

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!
==============================================

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

thanks!


  #4   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default

On Tue, 15 Feb 2005 05:25:01 -0800, Jan wrote:

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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
need to find which numbers (3+) in a column sum to a value Devin Excel Discussion (Misc queries) 1 February 11th 05 11:30 PM
How can I cross reference phone numbers with existing phone numbe. John Excel Discussion (Misc queries) 1 February 11th 05 05:39 PM
I cannot get a column of numbers to sum, why? HHG Excel Discussion (Misc queries) 8 February 8th 05 01:55 PM
I cannot get a column of numbers to sum, why? HHG Excel Worksheet Functions 4 February 8th 05 05:23 AM
How to insert a repeating dash in phone numbers without dashes in. LemonLiptonTea New Users to Excel 3 February 5th 05 06:18 PM


All times are GMT +1. The time now is 09:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"