CONCATENATE

[anne]

I have been trying to use the CONCATENATE

 

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

 

[Tim Otero]

Glad to hear that

 

[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

 

[Ken Wright]

LOL

 

[Tim Otero]

I couldn't help myself

--
tim

Common sense is the deposit of prejudice laid down in the mind before the
age of 18
-Albet Einstein