CONCATENATE REFUSES TO COMPUTE

  • Thread starter Thread starter stigarne
  • Start date Start date
S

stigarne

After inserting a column in an excel sheet with appr 500 rows and inserting
"=CONCATENATE("textstring";E2)" into F2 the function refuses to compute. The
content of the cell equals the inserted expression. Calcuate set to NOW.
Testing with a blank sheet CONCATENATE works as expected. I use Excel 2007
running XPPsp2.

Ideas ANYONE?
 
If you are using a US version of Excel, the semicolon should be a comma in
your formula.

Could be maybe your Calculations is set to Manual?

Vaya con Dios,
Chuck, CABGx3
 
Likely the cell was preformatted for text, and so consideres the contents to
be a string instead of an expression.

Jerry
 
LOL........boy, did I miss the point........good catch Jerry

Vaya con Dios,
Chuck, CABGx3
 
You really hit the nail there Jerry. I am am impressed, humbled and grateful.

/stigarne
 
You must log in or register to reply here.

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

Excel Concatenate with line breaks but ignore blank cells 3
How to CONCATENATE >50 fields in Excel table into SQL Insert State 3
Concatenate not working 2
Concatenate cells from M9 to Last row in M 2
CONCATENATE within SUMPRODUCT 14
Alternative to Concatenate 5
Getting Cell Value from the Concatenate formula 1
CONCATENATE 3

Back
Top