Re: 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" <mtmw@xxxxxxxxxxxxxxx> wrote in message
news:uf5x7p90GHA.328@xxxxxxxxxxxxxxxxxxxxxxx
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



.

Relevant Pages

  • Re: VLOOKUP AND #N/A
    ... Please keep all correspondence within the NewsGroup, ... I tried 3 other answers given in the archives first but still haven't been ... I'm looking for for an exact match to A6 in column H of my VLOOKUP table ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Substituting values
    ... Sounds like Vlookup should work for you. ... Check out this site of Debra Dalgleish on this function: ... Please keep all correspondence within the NewsGroup, ...
    (microsoft.public.excel.misc)
  • Re: Help! Probably dumb newbie question but need help with if/then??
    ... Vlookup should do what you want. ... Check out this web page of Debra Dalgleish on the function: ... Please keep all correspondence within the NewsGroup, ...
    (microsoft.public.excel.newusers)
  • Re: Vlookup with other formulas
    ... Add another column to your datalist, where you perform these calculations, ... and then return that column's values using the Vlookup. ... Please keep all correspondence within the NewsGroup, ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Vlookup if #N/A then enter enter data in cell I4
    ... Please keep all correspondence within the NewsGroup, ... worksheet doesn't contain a match the vlookup brings back a "#N/A" like it ...
    (microsoft.public.excel.misc)