On Sat, 10 May 2008 05:29:44 -0400, "Rick Rothstein \(MVP - VB\)"
wrote:

=--(PROPER(A1)&" "&B1&", "&YEAR(NOW()))

Hit <Enter too quickly:

At least in Excel 2007

=--(A1&B1) will do the same thing.
--ron