combine cells
 

Hello, say you have Mindy in A1, Thomas in B1, how can you combine those in
C1 with a space between the names?

combine cells
 

Mindy, here is one way,

=A1& " " & B1
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Mindy" wrote in message
...
Hello, say you have Mindy in A1, Thomas in B1, how can you combine those
in
C1 with a space between the names?

combine cells
 

I'm sorry I forgot one column, so I have the formula as =A1&" "& B1" "& C1
but it doesn't like the B1.

"Paul B" wrote:

Mindy, here is one way,

=A1& " " & B1
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Mindy" wrote in message
...
Hello, say you have Mindy in A1, Thomas in B1, how can you combine those
in
C1 with a space between the names?

combine cells
 

Mindy, you need one more &,

=A1&" "& B1&" "& C1
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Mindy" wrote in message
...
I'm sorry I forgot one column, so I have the formula as =A1&" "& B1" "& C1
but it doesn't like the B1.

"Paul B" wrote:

Mindy, here is one way,

=A1& " " & B1
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Mindy" wrote in message
...
Hello, say you have Mindy in A1, Thomas in B1, how can you combine
those
in
C1 with a space between the names?

combine cells
 

thanks


"Paul B" wrote:

Mindy, you need one more &,

=A1&" "& B1&" "& C1
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Mindy" wrote in message
...
I'm sorry I forgot one column, so I have the formula as =A1&" "& B1" "& C1
but it doesn't like the B1.

"Paul B" wrote:

Mindy, here is one way,

=A1& " " & B1
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Mindy" wrote in message
...
Hello, say you have Mindy in A1, Thomas in B1, how can you combine
those
in
C1 with a space between the names?