concatenation

[Cathy]

I'm trying to concatenate two text columns:

A2 = Public School
B2 = ;Annual Report

I would like C2 to = Public School;Annual Report

In C2 I am using the formula:
=CONCATENATE(A2,B2)

and that's exactly what shows in the cell instead of my
desired result. How can I get this to convert to the
results of the function?

Thanks,
Cathy

 

[JMay]

Format cell C2 as Number, General.

 

[Bradley Dawson]

What you're using should work but I like the ampersand better.
Try this:
= A2 & B2

if you had two numbers in those cells you could do something like:
= A2 & " is the annual expenditure for " & B2
where A2 is 13000 and B2 is 2003 and would look like
"13000 is the annual expenditure for 2003"
If you need to format the numbers, use the TEXT function:
=TEXT(A1,"$#,###") & " is the annual expenditure for " &A2
The part in the parenthesis with the dollar sign is number formatting. See
Help files.
Hope this helps

 

[RagDyer]

Your cell containing the formula is formatted as "Text".
You must format as "General" *before* you enter the formula.

To change one or two cells "after the fact", try:
Select cell,
<Ctrl> <Shift> <~>,
<F2>
<Enter>

If you have a great many cells already entered incorrectly (wrong format),
try this:

Select all the cells, then
<Edit> <Replace>
Find What "=" (no quotes)
Replace With "=" (no quotes)
Click "Replace All"
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I'm trying to concatenate two text columns:

A2 = Public School
B2 = ;Annual Report

I would like C2 to = Public School;Annual Report

In C2 I am using the formula:
=CONCATENATE(A2,B2)

and that's exactly what shows in the cell instead of my
desired result. How can I get this to convert to the
results of the function?

Thanks,
Cathy

 

[Cathy]

This solved it. Thanks much. At first it just
said "Public". Then I expanded the column and the rest of
the text was visible. Appreciate everyone's help.