Excel formulae to output text and number

robert32
02-12-2008, 03:17 AM
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
02-12-2008, 03:37 AM
You can concatenate a string together either using an ampersand (&) or by using the concatenate worksheet function.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum