Concatenation not working in Excel 2003

G

gschoser

I have two fields that I am trying to concatenate. When I use th
concatenate function: =CONCATENATE(F2,E2), it does not show the tw
concatenated fields it only shows the function. The same thing happen
when I do =F2& " " &E2.

I have tried this with several different worksheets and none of the
are working.

Any suggestions before I pull my hair out.

Thanks

Gretchen :
 
S

scottymelloty

right click and format the cell where you are putting the formula an
set it to general im guessing you have it set to tex
 
G

Gord Dibben

Or if all sheets and cells........you are set to "view formulas"

Hit CRTL + `(backquote above TAB key) to toggle on/off.

Gord Dibben Excel MVP
 
S

scottymelloty

Yes its what i said the cell that you have =CONCATENATE(F2,E2) needs to
be formatted as GENERAL and NOT Text , then you need to retype the
formula back into the cell
 
Top