adding duplicate text to multiple cells
 

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.

"
and copy the formula down 700 rows,


"beardic" wrote in message
...
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 & "

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

HTH,
Paul

"beardic" wrote in message
...
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.

Hi
You could use a helper column with
"
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.

"beardic" wrote in message
...
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.

=hyperlink("mailto:" & a1 & ")

is another option

beardic wrote:

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.

--

Dave Peterson