software

I have a column of telephone numbers. I need to change the area code and
first three digits of each of these numbers to a new area code and new
first thee digits. Example: 5555555555 change to (444)444-5555. notice
the last four digits need to stay the same.
If I have 100 numbers to change, the last 4 digits will be 100 unique
numbers. The formula =value(“444444”amp;right(a1:a100,4)) works however I
need to do this as part of a Macro ( for ease to the person using the
spreadsheet ) need some help PLEASE !!! thanks--
Hemming
------------------------------------------------------------------------
Hemming's Profile: www.excelforum.com/member.php...oamp;userid=32185
View this thread: www.excelforum.com/showthread...hreadid=520558For instance:
Range(quot;B2:B100quot;).Formula=quot;=VALUE(quot;quot;444444quot;quot;amp;RIGHT( A1,4))

HTH
--
AP

quot;Hemmingquot; gt; a écrit
dans le message de
...
gt;
gt; I have a column of telephone numbers. I need to change the area code and
gt; first three digits of each of these numbers to a new area code and new
gt; first thee digits. Example: 5555555555 change to (444)444-5555. notice
gt; the last four digits need to stay the same.
gt; If I have 100 numbers to change, the last 4 digits will be 100 unique
gt; numbers. The formula =value(quot;444444quot;amp;right(a1:a100,4)) works however I
gt; need to do this as part of a Macro ( for ease to the person using the
gt; spreadsheet ) need some help PLEASE !!! thanks
gt;
gt;
gt; --
gt; Hemming
gt; ------------------------------------------------------------------------
gt; Hemming's Profile:
www.excelforum.com/member.php...oamp;userid=32185
gt; View this thread: www.excelforum.com/showthread...hreadid=520558
gt;
See your previous post.

Hemming wrote:
gt;
gt; I have a column of telephone numbers. I need to change the area code and
gt; first three digits of each of these numbers to a new area code and new
gt; first thee digits. Example: 5555555555 change to (444)444-5555. notice
gt; the last four digits need to stay the same.
gt; If I have 100 numbers to change, the last 4 digits will be 100 unique
gt; numbers. The formula =value(“444444”amp;right(a1:a100,4)) works however I
gt; need to do this as part of a Macro ( for ease to the person using the
gt; spreadsheet ) need some help PLEASE !!! thanks
gt;
gt; --
gt; Hemming
gt; ------------------------------------------------------------------------
gt; Hemming's Profile: www.excelforum.com/member.php...oamp;userid=32185
gt; View this thread: www.excelforum.com/showthread...hreadid=520558

--

Dave Peterson