| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting "quotes" around characaters in a cell | Excel Discussion (Misc queries) | |||
| Inserting a link inside a "what-if" equation | Excel Discussion (Misc queries) | |||
| Inserting new data before "calculating cells" is done??? | Excel Discussion (Misc queries) | |||
| inserting a conditional "go to" command on a excel "if" function | Excel Worksheet Functions | |||
| When inserting a simple "Sum" formula all I get is the formula. | Charts and Charting in Excel | |||
Threaded Mode
