M
Mindy
Hello, say you have Mindy in A1, Thomas in B1, how can you combine those in
C1 with a space between the names?
C1 with a space between the names?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Paul B
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
=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
M
Mindy
I'm sorry I forgot one column, so I have the formula as =A1&" "& B1" "& C1
but it doesn't like the B1.
but it doesn't like the B1.
P
Paul B
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
=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
M
Mindy
thanks
Paul B said: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