quotation marks

Hello,

I'm trying to include a quotation mark in a concatenated cell. The numbers
in the cells have been converted to text.

Cell1=28 Cell2=36
My formula is =(cell1 & " x " & cell2)

What is returned is 28 x 36

How can I get the concatenated cell to read 28" x 36".

Thanks
John

Hi!

Try this:

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

If that's hard to see, it's 4 double quotes after the &'s.

Biff

"JohnF" <[email protected]> wrote in message
news:[email protected]...
> Hello,
>
> I'm trying to include a quotation mark in a concatenated cell. The numbers
> in the cells have been converted to text.
>
> Cell1=28 Cell2=36
> My formula is =(cell1 & " x " & cell2)
>
> What is returned is 28 x 36
>
> How can I get the concatenated cell to read 28" x 36".
>
> Thanks
> John

Thanks Biff. The quotes are there now, but there is another problem. When
the number is a fraction there is a space between the fraction and the quote;
ie
28 3/4 ", not 28 3/4". I'm using the Trim function. Any suggestions?

"Biff" wrote:

> Hi!
>
> Try this:
>
> =A1&""""&" x "&B1&""""
>
> If that's hard to see, it's 4 double quotes after the &'s.
>
> Biff
>
> "JohnF" <[email protected]> wrote in message
> news:[email protected]...
> > Hello,
> >
> > I'm trying to include a quotation mark in a concatenated cell. The numbers
> > in the cells have been converted to text.
> >
> > Cell1=28 Cell2=36
> > My formula is =(cell1 & " x " & cell2)
> >
> > What is returned is 28 x 36
> >
> > How can I get the concatenated cell to read 28" x 36".
> >
> > Thanks
> > John
>
>
>

That does not match your original question. So it is not clear what you did.
I would TRIM the original data and possibly use formatting for the
double quote (for inches).

A macro to TRIM original data values (not formulas) can be found in
http://www.mvps.org/dmcritchie/excel/join.htm#trimall

or with a worksheet formula
A1: 28 3/4_ where _ is a space
B1: =TRIM(A1) & """"


HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"JohnF" <[email protected]> wrote in message news:[email protected]...
> Thanks Biff. The quotes are there now, but there is another problem. When
> the number is a fraction there is a space between the fraction and the quote;
> ie
> 28 3/4 ", not 28 3/4". I'm using the Trim function. Any suggestions?
>
> "Biff" wrote:
>
> > Hi!
> >
> > Try this:
> >
> > =A1&""""&" x "&B1&""""
> >
> > If that's hard to see, it's 4 double quotes after the &'s.
> >
> > Biff
> >
> > "JohnF" <[email protected]> wrote in message
> > news:[email protected]...
> > > Hello,
> > >
> > > I'm trying to include a quotation mark in a concatenated cell. The numbers
> > > in the cells have been converted to text.
> > >
> > > Cell1=28 Cell2=36
> > > My formula is =(cell1 & " x " & cell2)
> > >
> > > What is returned is 28 x 36
> > >
> > > How can I get the concatenated cell to read 28" x 36".
> > >
> > > Thanks
> > > John
> >
> >
> >

Try this:

=TRIM(A1)&""""&" x "&TRIM(B1)&""""

Biff

"JohnF" <[email protected]> wrote in message
news:[email protected]...
> Thanks Biff. The quotes are there now, but there is another problem.
> When
> the number is a fraction there is a space between the fraction and the
> quote;
> ie
> 28 3/4 ", not 28 3/4". I'm using the Trim function. Any suggestions?
>
> "Biff" wrote:
>
>> Hi!
>>
>> Try this:
>>
>> =A1&""""&" x "&B1&""""
>>
>> If that's hard to see, it's 4 double quotes after the &'s.
>>
>> Biff
>>
>> "JohnF" <[email protected]> wrote in message
>> news:[email protected]...
>> > Hello,
>> >
>> > I'm trying to include a quotation mark in a concatenated cell. The
>> > numbers
>> > in the cells have been converted to text.
>> >
>> > Cell1=28 Cell2=36
>> > My formula is =(cell1 & " x " & cell2)
>> >
>> > What is returned is 28 x 36
>> >
>> > How can I get the concatenated cell to read 28" x 36".
>> >
>> > Thanks
>> > John
>>
>>
>>

Thanks guys. That did it.

John

"Biff" wrote:

> Try this:
>
> =TRIM(A1)&""""&" x "&TRIM(B1)&""""
>
> Biff
>
> "JohnF" <[email protected]> wrote in message
> news:[email protected]...
> > Thanks Biff. The quotes are there now, but there is another problem.
> > When
> > the number is a fraction there is a space between the fraction and the
> > quote;
> > ie
> > 28 3/4 ", not 28 3/4". I'm using the Trim function. Any suggestions?
> >
> > "Biff" wrote:
> >
> >> Hi!
> >>
> >> Try this:
> >>
> >> =A1&""""&" x "&B1&""""
> >>
> >> If that's hard to see, it's 4 double quotes after the &'s.
> >>
> >> Biff
> >>
> >> "JohnF" <[email protected]> wrote in message
> >> news:[email protected]...
> >> > Hello,
> >> >
> >> > I'm trying to include a quotation mark in a concatenated cell. The
> >> > numbers
> >> > in the cells have been converted to text.
> >> >
> >> > Cell1=28 Cell2=36
> >> > My formula is =(cell1 & " x " & cell2)
> >> >
> >> > What is returned is 28 x 36
> >> >
> >> > How can I get the concatenated cell to read 28" x 36".
> >> >
> >> > Thanks
> >> > John
> >>
> >>
> >>
>
>
>

And use ALT+0215 (×) for the multiplication sign - it looks more
professional than (x)

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"JohnF" <[email protected]> wrote in message
news:[email protected]...
> Hello,
>
> I'm trying to include a quotation mark in a concatenated cell. The numbers
> in the cells have been converted to text.
>
> Cell1=28 Cell2=36
> My formula is =(cell1 & " x " & cell2)
>
> What is returned is 28 x 36
>
> How can I get the concatenated cell to read 28" x 36".
>
> Thanks
> John

Thanks Bernard. I'll give it a try.
John

"Bernard Liengme" wrote:

> And use ALT+0215 (×) for the multiplication sign - it looks more
> professional than (x)
>
> --
> Bernard V Liengme
> www.stfx.ca/people/bliengme
> remove caps from email
>
> "JohnF" <[email protected]> wrote in message
> news:[email protected]...
> > Hello,
> >
> > I'm trying to include a quotation mark in a concatenated cell. The numbers
> > in the cells have been converted to text.
> >
> > Cell1=28 Cell2=36
> > My formula is =(cell1 & " x " & cell2)
> >
> > What is returned is 28 x 36
> >
> > How can I get the concatenated cell to read 28" x 36".
> >
> > Thanks
> > John
>
>
>