View Single Post
  #4   Report Post  
CLR
 
Posts: n/a
Default

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?