View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RagDyer
 
Posts: n/a
Default Combining cell reference with text

Thanks for the feed-back, but ... just so you realize ...
you asked for:
" - yy"
But you seem to have accepted:
" - dd".
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"mattflow" wrote in
message ...

=TEXT(A1,"mmmm - dd")&" to "&TEXT(A2,"mmmm - dd")

That did it, thanks guys!


--
mattflow
------------------------------------------------------------------------
mattflow's Profile:

http://www.excelforum.com/member.php...o&userid=25129
View this thread: http://www.excelforum.com/showthread...hreadid=490836