adding duplicate text to multiple cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have alist of about 700 names that I need to turn into E-mail addresses.
For instance I need to add @***.net to each user name. Is there a way to do
this without typing it 700 times.
 
One way:

If your list is in column A, you could add a formula in column B.

In B1:
=A1 & "@***.net"

Then copy cell B1 down as many rows as you need.

HTH,
Paul
 
Hi
You could use a helper column with
=A2&"@****.net"
in it. This will not actually create hyperlinks, though. To replace the
formulas with the actual values, copy the range and select Edit|Paste
Special|Values
Make sure you take a copy before you start!

Andy.
 
You must log in or register to reply here.

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

Similar Threads

Adding cell labels to multiple single cells 7
trying to insert a 0 in front of zipcode 2
Transposing Multiple Cell References to Multiple Values (NOT total 7
Transposing Multiple Cell references as Multiple Values 1
Insert extra lines 3
Index/match across multiple columns? 19
Sort with IF functions? 5
Find duplicates in address register 2

Back
Top