Concatenation not working in Excel 2003

  • Thread starter Thread starter gschoser
  • Start date Start date
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 :
 
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
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

concatenate 5
How to CONCATENATE >50 fields in Excel table into SQL Insert State 3
Concatenate not working 2
Concatenate Problem 1
Keeping format while concatenating 2
Concatenation 2
Concatenate Formula not working 6
Excel Concatenate with line breaks but ignore blank cells 3

Back
Top