formatting a column

S

S Davis

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
 
M

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
 
S

S Davis

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.
 
G

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
 
M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top