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

quotation marks
 

Hi!

Try this:

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

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

Biff

"JohnF" wrote in message
...
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

quotation marks
 

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" wrote in message
...
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

quotation marks
 

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" wrote in message ...
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" wrote in message
...
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

quotation marks
 

Try this:

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

Biff

"JohnF" wrote in message
...
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" wrote in message
...
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

quotation marks
 

Thanks guys. That did it.

John

"Biff" wrote:

Try this:

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

Biff

"JohnF" wrote in message
...
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" wrote in message
...
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

quotation marks
 

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" wrote in message
...
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

quotation marks
 

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" wrote in message
...
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