Try this to concatenate:

C1 contains the text,
20 days in

SO ...

=C1&" "&TEXT(A2,"mmmm")

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"MartinW" wrote in message
...
Yeah tried that RD but I'm cocatenating the result and that
returns a value of 38969 instead of september for the cell
even though it displays as september. The Vlookup works
fine so I might just stick with that.

Thanks for postig
Martin