MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Concantenated columns won't display the value

Posted by Jerald on January 31, 2002 9:28 PM

Someone sent me an excel sheet that I needed to concantenate a few of the columns. It allows me to put the formula in but that's all it displays and when you drag the formula thru the rows it keeps the original formula not adjusting for new rows to concantenate.


Posted by anno on January 31, 2002 10:08 PM

to have the sheet display values rather than formulas, go to tools menu>options>view tab and uncheck the 'formulas' item.
sounds like the formula has absolute rather than relative references. remove any '$'signs and it should work.
if that doesn't work i think the file has been corrupted.

Posted by anno on February 03, 2002 8:36 PM

jerald - this post might hold the answer - 19916.html [nt]