if they arent in a column, where would you add the formaula to append ?


"CLR" wrote:

Assuming your list is in column A, in B1 put this formula and copy
down..........

=A1&"SMTP:"

Vaya con Dios,
Chuck, CABGx3



"Shane" wrote in message
...
I have a 1 page workbook of email addresses. I would like to apend SMTP:
to
each address in a row. How can I do this without going to each cell and
pasting?