Hello,

If I have this:

A1 B1 C1
HI YO

What form can I insert in C1 so it automatically takes the info from A1 and
A2 and put it there. I would also like to put a coma followed by a space
between the 2 info. So in this example, I would like to have HI, YO in cell
C1.

Thanks!!!

In C1: =A1&", "&B1
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"One-Leg" wrote:
Hello,

If I have this:

A1 B1 C1
HI YO

What form can I insert in C1 so it automatically takes the info from A1 and
A2 and put it there. I would also like to put a coma followed by a space
between the 2 info. So in this example, I would like to have HI, YO in cell
C1.

Thanks!!!

Use this!
=+A1&", "&A2
your results will be! Hi, YO




"One-Leg" wrote:

Hello,

If I have this:

A1 B1 C1
HI YO

What form can I insert in C1 so it automatically takes the info from A1 and
A2 and put it there. I would also like to put a coma followed by a space
between the 2 info. So in this example, I would like to have HI, YO in cell
C1.

Thanks!!!

Others have written the formula for you but in case you need to know, this
funtion is called CONCATENATE. It can be found under the Text Category of
the Insert Functions Menu. Sometimes it is easier to use the function wizard
with formulas like these because special characters are involved.
--
Hope this helps.

Matt S.


"One-Leg" wrote:

Hello,

If I have this:

A1 B1 C1
HI YO

What form can I insert in C1 so it automatically takes the info from A1 and
A2 and put it there. I would also like to put a coma followed by a space
between the 2 info. So in this example, I would like to have HI, YO in cell
C1.

Thanks!!!

In C1 enter =A1 & ", " & B1


Gord Dibben MS Excel MVP

On Fri, 8 Dec 2006 09:06:01 -0800, One-Leg
wrote:

Hello,

If I have this:

A1 B1 C1
HI YO

What form can I insert in C1 so it automatically takes the info from A1 and
A2 and put it there. I would also like to put a coma followed by a space
between the 2 info. So in this example, I would like to have HI, YO in cell
C1.

Thanks!!!