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