Escape character for double quotes

I have AAA in cell A1 and BBB in cell B1 and I want to use the concatenate function to output the below in cell C1 but I having trouble printing double quotes ".


AAA"BBB"


Could someone please tell me the escape charater to do this?

Hi!

Try this:

=A1&""""&B1&""""

That's 4 double quotes on each side if it's had to distinguish.

Biff

"SteveFox" <[email protected]> wrote in
message news:[email protected]...
>
> I have AAA in cell A1 and BBB in cell B1 and I want to use the
> concatenate function to output the below in cell C1 but I having
> trouble printing double quotes ".
>
>
> AAA"BBB"
>
>
> Could someone please tell me the escape charater to do this?
>
>
> --
> SteveFox
> ------------------------------------------------------------------------
> SteveFox's Profile:
> http://www.excelforum.com/member.php...o&userid=28975
> View this thread: http://www.excelforum.com/showthread...hreadid=495718
>

Steve

=A1 & """" & B1 & """"


Gord Dibben Excel MVP

On Fri, 23 Dec 2005 01:02:42 -0600, SteveFox
<[email protected]> wrote:

>
>I have AAA in cell A1 and BBB in cell B1 and I want to use the
>concatenate function to output the below in cell C1 but I having
>trouble printing double quotes ".
>
>
>AAA"BBB"
>
>
>Could someone please tell me the escape charater to do this?

And when you get really frustrated...

=A1&CHAR(34)&B1&CHAR(34)



SteveFox wrote:
>
> I have AAA in cell A1 and BBB in cell B1 and I want to use the
> concatenate function to output the below in cell C1 but I having
> trouble printing double quotes ".
>
> AAA"BBB"
>
> Could someone please tell me the escape charater to do this?
>
> --
> SteveFox
> ------------------------------------------------------------------------
> SteveFox's Profile: http://www.excelforum.com/member.php...o&userid=28975
> View this thread: http://www.excelforum.com/showthread...hreadid=495718

--

Dave Peterson

>And when you get really frustrated...

That never happens, does it?

Biff

"Dave Peterson" <[email protected]> wrote in message
news:[email protected]...
> And when you get really frustrated...
>
> =A1&CHAR(34)&B1&CHAR(34)
>
>
>
> SteveFox wrote:
>>
>> I have AAA in cell A1 and BBB in cell B1 and I want to use the
>> concatenate function to output the below in cell C1 but I having
>> trouble printing double quotes ".
>>
>> AAA"BBB"
>>
>> Could someone please tell me the escape charater to do this?
>>
>> --
>> SteveFox
>> ------------------------------------------------------------------------
>> SteveFox's Profile:
>> http://www.excelforum.com/member.php...o&userid=28975
>> View this thread:
>> http://www.excelforum.com/showthread...hreadid=495718
>
> --
>
> Dave Peterson

Doh!


Biff wrote:
>
> >And when you get really frustrated...
>
> That never happens, does it?
>
> Biff
>
> "Dave Peterson" <[email protected]> wrote in message
> news:[email protected]...
> > And when you get really frustrated...
> >
> > =A1&CHAR(34)&B1&CHAR(34)
> >
> >
> >
> > SteveFox wrote:
> >>
> >> I have AAA in cell A1 and BBB in cell B1 and I want to use the
> >> concatenate function to output the below in cell C1 but I having
> >> trouble printing double quotes ".
> >>
> >> AAA"BBB"
> >>
> >> Could someone please tell me the escape charater to do this?
> >>
> >> --
> >> SteveFox
> >> ------------------------------------------------------------------------
> >> SteveFox's Profile:
> >> http://www.excelforum.com/member.php...o&userid=28975
> >> View this thread:
> >> http://www.excelforum.com/showthread...hreadid=495718
> >
> > --
> >
> > Dave Peterson

--

Dave Peterson