In some of my older spreadsheets, when I try to concatenate, I get a "Value"
Error. Specifically, the formula reads =c1&" Plan". I works in some
spreadsheets, but not in others. I generally update or make changes to old
spreadsheets. Could it be because they may have come from older versions of
Excel?