Trouble with concatenation.

[Jim Moberg]

Hi,

I'm trying to concatenate a number of cells together using the concatenate
function and am having some trouble. Basically the formula is showing up in
the cell without the actual concatenated value. I have removed any leading
spaces and the "=" sign is in place but the only thing I see is the formula.
What would cause this?

 

[JE McGimpsey]

Your cell is formatted as Text. Change it to General.

 

[Jim Moberg]

I have done this and it had no effect.

Your cell is formatted as Text. Change it to General.

 

[Dave Peterson]

Change the cell's format to General
Then select the cell, Hit F2 and then enter.
(This is the equivalent of reentering the formula)

If that doesn't help, try:
tools|Options|View Tab|Uncheck Formulas
(Maybe you're looking at formulas--not what they evaluate to.)

 

[Jim Moberg]

Thanks,

I figured out that I was missing some commas to separate each item I need to
contatenate.