Inserting " in a formula
="The date today is "&""""&TEXT(TODAY(),"dd-mmm-yyyy")&""""
On Aug 13, 8:34*am, FARAZ QURESHI
wrote:
How can I insert inverted commas in a formula. For example:
="The date today is "&TEXT(TODAY(),"dd-mmm-yyyy")
reflects:
The date today is 13-Aug-2008
but how can I achieve a result like:
The date today is "13-Aug-2008"
--
Best Regards,
FARAZ A. QURESHI
|