WEEKDAY()
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
|