| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
displaying output of a formula to be in double quotes
I am trying to generate the output of a formula to include the value within
double quotes. Can anyone help, or am I out of luck? -- Mike Scala |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
displaying output of a formula to be in double quotes
=(1+1) & " HELLO WORLD"
-- Gary's Student gsnu200702 "Mike Scala" wrote: I am trying to generate the output of a formula to include the value within double quotes. Can anyone help, or am I out of luck? -- Mike Scala |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
displaying output of a formula to be in double quotes
Try this:
=""""&your_formula&"""" That's 4 quotes on either side of the formula. Does that help? *********** Regards, Ron XL2002, WinXP "Mike Scala" wrote: I am trying to generate the output of a formula to include the value within double quotes. Can anyone help, or am I out of luck? -- Mike Scala |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
displaying output of a formula to be in double quotes
=""""&H6+I6&""""
adds h6 and i6 and adds the quotes "Mike Scala" wrote: I am trying to generate the output of a formula to include the value within double quotes. Can anyone help, or am I out of luck? -- Mike Scala |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
displaying output of a formula to be in double quotes
Format Cell Custom
''General'' the are pars of SINGLE quotes not double before/after -- Gary's Student gsnu200702 "Mike Scala" wrote: I am trying to generate the output of a formula to include the value within double quotes. Can anyone help, or am I out of luck? -- Mike Scala |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
displaying output of a formula to be in double quotes
Do you mean something like this in say, G1:
=""""&SUM(E1:F1)&"""" If E1:F1 contains the numbers: 1, 2 G1 returns: "3" -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Mike Scala" wrote: I am trying to generate the output of a formula to include the value within double quotes. Can anyone help, or am I out of luck? -- Mike Scala |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
displaying output of a formula to be in double quotes
One more...
=char(34) & a1&b1 & char(34) Mike Scala wrote: I am trying to generate the output of a formula to include the value within double quotes. Can anyone help, or am I out of luck? -- Mike Scala -- Dave Peterson |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
displaying output of a formula to be in double quotes
Obviously, we all just took a guess at what you're working with and came up
with various solutions. That just emphasizes the importance of including formulas and sample data when posting questions. *********** Regards, Ron XL2002, WinXP "Mike Scala" wrote: I am trying to generate the output of a formula to include the value within double quotes. Can anyone help, or am I out of luck? -- Mike Scala |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying cell values to a external file in VBA | Excel Discussion (Misc queries) | |||
| Is it possible? | Excel Worksheet Functions | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| Match then lookup | Excel Worksheet Functions | |||
| How do you copy a cell formula down a column without displaying n. | Excel Worksheet Functions | |||
Hybrid Mode
