Anne this will put whats in A1 and B1 in one cell, with a space between
them, does this help
=CONCATENATE(A1," ",B1)
--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
There is no need to use CONCATENATE because the & operator works the same
way. It joins items exactly as you'd think it would. A few examples:
A B C Result
1 55 66 =A1&B1 5566
2 Bert Ernie =A1&" and "&B1 Bert and Ernie
3 This is a =A1&B1&" Formula" This is a Formula
4 88 2 ="The result is: "&A1/A2 The result is: 44
HTH
tim
ps please excuse my smart ass comments from earlier
Common sense is the deposit of prejudice laid down in the mind before the
age of 18
-Albet Einstein
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
