Concatenate numbers
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?
|