formatting a column

[Guest]

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

 

[MartinW]

Hi,

For data in column A put this in column B and drag down as
far as needed.
=A1&"@rcfax.com"

To make them hyperlinked use
=HYPERLINK(A1&"@rcfax.com")

HTH
Martin

 

[Guest]

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.

 

[Gord Dibben]

How about two passes with Edit>Replace?

One for ( and one for )

Replace with nothing in both passes.


Gord Dibben MS Excel MVP

 

[MartinW]

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 Edit>Find otherwise you will also change
all the other formulas in your worksheet.

HTH
Martin