Adding numbers to several cells at one time
 

Hi, this may be quite simple but I can't seem to figure it out. Please help

I have a list (Column) of phone numbers in the XXX-XXXX format. I'd like to
add the Area code (which is the same for them all) and make this list display
in the XXX-XXX-XXXX

Any help? Thanks
--
Bob

Hi Bob

You could use the concatenate function

Assuming the first phone number is in cell A2 in cell B2 enter
=CONCATENATE("XXX-",A2), where "XXX" is the Area Code, then copy this
down the column, the highlight the whole column and copy paste
special values

Paul


--
Paul Sheppard
------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=394244

One way:

Enter your area code in an unused cell, for example, in D1:

213-

Then, with you original numbers in Column A, enter this formula in B1, and
copy down as needed:

=$D$1&A1

--

HTH,

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


"Bob" wrote in message
...
Hi, this may be quite simple but I can't seem to figure it out. Please help

I have a list (Column) of phone numbers in the XXX-XXXX format. I'd like to
add the Area code (which is the same for them all) and make this list
display
in the XXX-XXX-XXXX

Any help? Thanks
--
Bob

See, I told you it was an easy one, I guess I just didn't consider the "&"
sign.

Your my hero, RD! Thanks
--
Bob


"RagDyeR" wrote:

One way:

Enter your area code in an unused cell, for example, in D1:

213-

Then, with you original numbers in Column A, enter this formula in B1, and
copy down as needed:

=$D$1&A1

--

HTH,

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


"Bob" wrote in message
...
Hi, this may be quite simple but I can't seem to figure it out. Please help

I have a list (Column) of phone numbers in the XXX-XXXX format. I'd like to
add the Area code (which is the same for them all) and make this list
display
in the XXX-XXX-XXXX

Any help? Thanks
--
Bob

Appreciate the feed-back.
--

Regards,

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

"Bob" wrote in message
...
See, I told you it was an easy one, I guess I just didn't consider the "&"
sign.

Your my hero, RD! Thanks
--
Bob


"RagDyeR" wrote:

One way:

Enter your area code in an unused cell, for example, in D1:

213-

Then, with you original numbers in Column A, enter this formula in B1, and
copy down as needed:

=$D$1&A1

--

HTH,

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


"Bob" wrote in message
...
Hi, this may be quite simple but I can't seem to figure it out. Please
help

I have a list (Column) of phone numbers in the XXX-XXXX format. I'd like
to
add the Area code (which is the same for them all) and make this list
display
in the XXX-XXX-XXXX

Any help? Thanks
--
Bob