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?