Only the Concatenate function will show in the cell, not the result. Any tips?

Check on the formula bar, does your formula have a space before the equal sign? MIKE

If the format of the cell is stuck on Text (which Excel has been known to do) the formula will show and not be treated as a formula. Sometimes even Format...Cells...Number (or whatever) won't change it.

Try another cell and see if you can get the formula to work. If so, select that cell, click the Format Painter icon and then click the troublesome cell.

Let us know if that works.

Ask Your Question

Weekly Poll