Chuck

You either have Formula View set to on or your cell with the formula is
formatted as text.

1. Hit CTRL + `(backquote above TAB key) to toggle view formulas off.

2. Format the formula cell as General then hit F2 then ENTER key.


Gord Dibben Excel MVP

On Mon, 31 Jan 2005 13:36:30 -0800, "Chuck W"
wrote:

Hi,

I am having trouble getting the concatenate function to
work. There are five columns of data I am trying to
combine which include Address1, Address2, City, State and
Zip. I have tried changing to formats from general to
text but they will not concatenate. Whenever I use the
function wizard, it simply says =concatenate
(a2,b2,c2,d2,d2) rather than combining my fields. Is
there setting I need to adjust?

Thanks,

Chuck