concatenation

  • Thread starter Thread starter Cathy
  • Start date Start date
C

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
 
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
 
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
 
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.
 
Back
Top