robert32

Hi,

Is there a way in Excel to use a formula (not VBA) to display text in a cell that is part made up of a String, part reference to a numeric value in another cell?

I am trying the following, but just getting the #VALUE! error returned:

="Change between " + YEAR(B9) + " and " + YEAR(C9)


Any help would be greatly appreciated.


Cheers,

Rob.

Colin Legg

You can concatenate a string together either using an ampersand (&) or by using the concatenate worksheet function.