Try it like this:

="month "&B4

(shorter to type). Perhaps you had an error in B4.

Hope this helps.

Pete

On May 2, 1:08*pm, Colin G wrote:
I want to be able to insert a phrase such as Month 3 where the month number
is entered in a different cell (say B4). I have therefore entered formula -
concatenate("month ",B4) and it returns a #value! error. Both cells have
general format. When I do this on a brand new spreadsheet i don't have a
problem in that it displays as Month 3 so there must be a problem on the
spreadsheet i am using which is causing this. Does anybody have any clues?