Excel formulae to output text and number

02-12-2008, 04:17 AM

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.



Colin Legg
02-12-2008, 04: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