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

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

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

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

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

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

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

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