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?
|