I need to add the same text to a column of phone numbers and cannot figure
out the best way to accomplish this -- any suggestions?

Example -- Rows already have 555-555-5555 need to add @rcfax.com to every
cell in that column

Hi,

For data in column A put this in column B and drag down as
far as needed.
"

To make them hyperlinked use
")

HTH
Martin

I knew there had to be something -- thanks so much.

Since that seemed easy for you -- is there a way to format all of the phone
numbers so they are all without ()? When I brought them in to the worksheet
some were formatted with and some without -- ie. (000) 000-0000 -- I need
them all to be 000-000-0000 +#rcfax.com.

"MartinW" wrote:

Hi,

For data in column A put this in column B and drag down as
far as needed.
"

To make them hyperlinked use
")

HTH
Martin

How about two passes with EditReplace?

One for ( and one for )

Replace with nothing in both passes.


Gord Dibben MS Excel MVP

On Sat, 3 Mar 2007 18:09:08 -0800, S Davis
wrote:

I knew there had to be something -- thanks so much.

Since that seemed easy for you -- is there a way to format all of the phone
numbers so they are all without ()? When I brought them in to the worksheet
some were formatted with and some without -- ie. (000) 000-0000 -- I need
them all to be 000-000-0000 +#rcfax.com.

"MartinW" wrote:

Hi,

For data in column A put this in column B and drag down as
far as needed.
"

To make them hyperlinked use
")

HTH
Martin

Hi,

Use Find and replace like this
Find what: ~(
Replace with: leave this box blank
Click replace all

Make sure you select only the data you want changed
before you goto EditFind otherwise you will also change
all the other formulas in your worksheet.

HTH
Martin