software

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 amp; quot; x quot; amp; cell2)

What is returned is 28 x 36

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

Thanks
John

Hi!

Try this:

=A1amp;quot;quot;quot;quot;amp;quot; x quot;amp;B1amp;quot;quot;quot;quot;

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

Biff

quot;JohnFquot; gt; wrote in message
...
gt; Hello,
gt;
gt; I'm trying to include a quotation mark in a concatenated cell. The numbers
gt; in the cells have been converted to text.
gt;
gt; Cell1=28 Cell2=36
gt; My formula is =(cell1 amp; quot; x quot; amp; cell2)
gt;
gt; What is returned is 28 x 36
gt;
gt; How can I get the concatenated cell to read 28quot; x 36quot;.
gt;
gt; Thanks
gt; 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 quot;, not 28 3/4quot;. I'm using the Trim function. Any suggestions?

quot;Biffquot; wrote:

gt; Hi!
gt;
gt; Try this:
gt;
gt; =A1amp;quot;quot;quot;quot;amp;quot; x quot;amp;B1amp;quot;quot;quot;quot;
gt;
gt; If that's hard to see, it's 4 double quotes after the amp;'s.
gt;
gt; Biff
gt;
gt; quot;JohnFquot; gt; wrote in message
gt; ...
gt; gt; Hello,
gt; gt;
gt; gt; I'm trying to include a quotation mark in a concatenated cell. The numbers
gt; gt; in the cells have been converted to text.
gt; gt;
gt; gt; Cell1=28 Cell2=36
gt; gt; My formula is =(cell1 amp; quot; x quot; amp; cell2)
gt; gt;
gt; gt; What is returned is 28 x 36
gt; gt;
gt; gt; How can I get the concatenated cell to read 28quot; x 36quot;.
gt; gt;
gt; gt; Thanks
gt; gt; John
gt;
gt;
gt;

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
www.mvps.org/dmcritchie/excel/join.htm#trimall

or with a worksheet formula
A1: 28 3/4_ where _ is a space
B1: =TRIM(A1) amp; quot;quot;quot;quot;HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

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

=TRIM(A1)amp;quot;quot;quot;quot;amp;quot; x quot;amp;TRIM(B1)amp;quot;quot;quot;quot;

Biff

quot;JohnFquot; gt; wrote in message
...
gt; Thanks Biff. The quotes are there now, but there is another problem.
gt; When
gt; the number is a fraction there is a space between the fraction and the
gt; quote;
gt; ie
gt; 28 3/4 quot;, not 28 3/4quot;. I'm using the Trim function. Any suggestions?
gt;
gt; quot;Biffquot; wrote:
gt;
gt;gt; Hi!
gt;gt;
gt;gt; Try this:
gt;gt;
gt;gt; =A1amp;quot;quot;quot;quot;amp;quot; x quot;amp;B1amp;quot;quot;quot;quot;
gt;gt;
gt;gt; If that's hard to see, it's 4 double quotes after the amp;'s.
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;JohnFquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Hello,
gt;gt; gt;
gt;gt; gt; I'm trying to include a quotation mark in a concatenated cell. The
gt;gt; gt; numbers
gt;gt; gt; in the cells have been converted to text.
gt;gt; gt;
gt;gt; gt; Cell1=28 Cell2=36
gt;gt; gt; My formula is =(cell1 amp; quot; x quot; amp; cell2)
gt;gt; gt;
gt;gt; gt; What is returned is 28 x 36
gt;gt; gt;
gt;gt; gt; How can I get the concatenated cell to read 28quot; x 36quot;.
gt;gt; gt;
gt;gt; gt; Thanks
gt;gt; gt; John
gt;gt;
gt;gt;
gt;gt;
Thanks guys. That did it.

John

quot;Biffquot; wrote:

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

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

quot;JohnFquot; gt; wrote in message
...
gt; Hello,
gt;
gt; I'm trying to include a quotation mark in a concatenated cell. The numbers
gt; in the cells have been converted to text.
gt;
gt; Cell1=28 Cell2=36
gt; My formula is =(cell1 amp; quot; x quot; amp; cell2)
gt;
gt; What is returned is 28 x 36
gt;
gt; How can I get the concatenated cell to read 28quot; x 36quot;.
gt;
gt; Thanks
gt; John
Thanks Bernard. I'll give it a try.
John

quot;Bernard Liengmequot; wrote:

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