Adding numbers to several cells at one time

[Bob]

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

 

[Paul Sheppard]

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

 

[RagDyeR]

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


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

 

[RagDyeR]

Appreciate the feed-back.
--

Regards,

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

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

Your my hero, RD! Thanks