| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting " in a formula
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Inserting " in a formula
To concatenate a quotation mark to a text string use 4 quotation marks as
illustrated below: =""""&TEXT(TODAY(),"dd-mmm-yyyy")&"""" -- Kevin Backmann "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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Inserting " in a formula
="The date today is "& CHAR(34) & TEXT(TODAY(),"dd-mmm-yyyy") & CHAR(34)
-- Gary''s Student - gsnu200800 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Inserting " in a formula
I prefer to use CHAR(34), like so:
="The date today is "&CHAR(34)&TEXT(TODAY(),"dd-mmm-yyyy")&CHAR(34) Or you could do it this way: ="The date today is """&TEXT(TODAY(),"dd-mmm-yyyy")&"""" Hope this helps. Pete On Aug 13, 1:34*pm, 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 |
|
#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 |
| Reply |
| 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 | |||
Linear Mode
