Hi,

I have tried both the concatenate function and the A1&B1, for example,
method.

In two separate workbooks, I have two different problems!

1. In one workbook, only the formula is displayed. As I enter it, it
refers to the cells referenced in colour, etc., as always, but as soon as I
hit Enter, only the formula is displayed, not the result.

2. In another workbook, the result is displayed, however, in many cells,
only the last 2 or 3 characters in the 2nd cell referenced is displayed.

I have never had these problems and have tried formatting in various ways,
looked up troubleshooting, but nothing seems to help.

Thanks!

--
Thanks!

Dee