How can you append text in multiple cells in excel?

Use the CONCATENATE() function... for example if you had "Joe" in A1 and
"Smith" in A2, the formula:

=CONCATENATE(A1," ",A2) would yield "Joe Smith"

You can also do this with the & symbol like so: =A1&" "&A2

--
Regards,
Dave


"Shane" wrote:

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

I would use a for/each macro
for each c in selection
c.value=c & "SMPT:"
next c

--
Don Guillett
SalesAid Software
[email protected]
"Shane" <[email protected]> wrote in message
news:[email protected]...
> 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?

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

=A1&"SMTP:"

Vaya con Dios,
Chuck, CABGx3



"Shane" <[email protected]> wrote in message
news:[email protected]...
> 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?

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

=A1&"SMTP:"

Vaya con Dios,
Chuck, CABGx3



"Shane" <[email protected]> wrote in message
news:[email protected]...
> 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?

Use the CONCATENATE() function... for example if you had "Joe" in A1 and
"Smith" in A2, the formula:

=CONCATENATE(A1," ",A2) would yield "Joe Smith"

You can also do this with the & symbol like so: =A1&" "&A2

--
Regards,
Dave


"Shane" wrote:

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

I would use a for/each macro
for each c in selection
c.value=c & "SMPT:"
next c

--
Don Guillett
SalesAid Software
[email protected]
"Shane" <[email protected]> wrote in message
news:[email protected]...
> 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?

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

=A1&"SMTP:"

Vaya con Dios,
Chuck, CABGx3



"Shane" <[email protected]> wrote in message
news:[email protected]...
> 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?

I would use a for/each macro
for each c in selection
c.value=c & "SMPT:"
next c

--
Don Guillett
SalesAid Software
[email protected]
"Shane" <[email protected]> wrote in message
news:[email protected]...
> 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?

Use the CONCATENATE() function... for example if you had "Joe" in A1 and
"Smith" in A2, the formula:

=CONCATENATE(A1," ",A2) would yield "Joe Smith"

You can also do this with the & symbol like so: =A1&" "&A2

--
Regards,
Dave


"Shane" wrote:

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

Use the CONCATENATE() function... for example if you had "Joe" in A1 and
"Smith" in A2, the formula:

=CONCATENATE(A1," ",A2) would yield "Joe Smith"

You can also do this with the & symbol like so: =A1&" "&A2

--
Regards,
Dave


"Shane" wrote:

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

I would use a for/each macro
for each c in selection
c.value=c & "SMPT:"
next c

--
Don Guillett
SalesAid Software
[email protected]
"Shane" <[email protected]> wrote in message
news:[email protected]...
> 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?

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

=A1&"SMTP:"

Vaya con Dios,
Chuck, CABGx3



"Shane" <[email protected]> wrote in message
news:[email protected]...
> 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?

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

=A1&"SMTP:"

Vaya con Dios,
Chuck, CABGx3



"Shane" <[email protected]> wrote in message
news:[email protected]...
> 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?

I would use a for/each macro
for each c in selection
c.value=c & "SMPT:"
next c

--
Don Guillett
SalesAid Software
[email protected]
"Shane" <[email protected]> wrote in message
news:[email protected]...
> 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?

Use the CONCATENATE() function... for example if you had "Joe" in A1 and
"Smith" in A2, the formula:

=CONCATENATE(A1," ",A2) would yield "Joe Smith"

You can also do this with the & symbol like so: =A1&" "&A2

--
Regards,
Dave


"Shane" wrote:

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

Use the CONCATENATE() function... for example if you had "Joe" in A1 and
"Smith" in A2, the formula:

=CONCATENATE(A1," ",A2) would yield "Joe Smith"

You can also do this with the & symbol like so: =A1&" "&A2

--
Regards,
Dave


"Shane" wrote:

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

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?

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

=A1&"SMTP:"

Vaya con Dios,
Chuck, CABGx3



"Shane" <[email protected]> wrote in message
news:[email protected]...
> 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?

I would use a for/each macro
for each c in selection
c.value=c & "SMPT:"
next c

--
Don Guillett
SalesAid Software
[email protected]
"Shane" <[email protected]> wrote in message
news:[email protected]...
> 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?

I would use a for/each macro
for each c in selection
c.value=c & "SMPT:"
next c

--
Don Guillett
SalesAid Software
[email protected]
"Shane" <[email protected]> wrote in message
news:[email protected]...
> 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?

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

=A1&"SMTP:"

Vaya con Dios,
Chuck, CABGx3



"Shane" <[email protected]> wrote in message
news:[email protected]...
> 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?

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

=A1&"SMTP:"

Vaya con Dios,
Chuck, CABGx3



"Shane" <[email protected]> wrote in message
news:[email protected]...
> 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?

I would use a for/each macro
for each c in selection
c.value=c & "SMPT:"
next c

--
Don Guillett
SalesAid Software
[email protected]
"Shane" <[email protected]> wrote in message
news:[email protected]...
> 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?

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

=A1&"SMTP:"

Vaya con Dios,
Chuck, CABGx3



"Shane" <[email protected]> wrote in message
news:[email protected]...
> 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?

I would use a for/each macro
for each c in selection
c.value=c & "SMPT:"
next c

--
Don Guillett
SalesAid Software
[email protected]
"Shane" <[email protected]> wrote in message
news:[email protected]...
> 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?

I would use a for/each macro
for each c in selection
c.value=c & "SMPT:"
next c

--
Don Guillett
SalesAid Software
[email protected]
"Shane" <[email protected]> wrote in message
news:[email protected]...
> 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?

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

=A1&"SMTP:"

Vaya con Dios,
Chuck, CABGx3



"Shane" <[email protected]> wrote in message
news:[email protected]...
> 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?

I would use a for/each macro
for each c in selection
c.value=c & "SMPT:"
next c

--
Don Guillett
SalesAid Software
[email protected]
"Shane" <[email protected]> wrote in message
news:[email protected]...
> 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?

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

=A1&"SMTP:"

Vaya con Dios,
Chuck, CABGx3



"Shane" <[email protected]> wrote in message
news:[email protected]...
> 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?

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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?
>
>
>