CONCATENATE

P

Paul B

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 **
 
T

Tim Otero

Anne,

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
 

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.

Ask a Question

Similar Threads

Concatenate cells with line breaks in them 4
BOLD WORDS IN CONCATENATE FORMULA 2
Formula to add two spaces into a number stored as text 4
Concatenate with hyphens answer 3
How specify number format of cell value in concatenate function? 1
Calculate the function in a cell that is created with CONCATENATE 2
concatenate 2
Concatenate question on limitations 4

Top