quotation marks

[Guest]

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

 

[Biff]

Hi!

Try this:

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

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

Biff

 

[Guest]

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?

 

[David McRitchie]

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

 

[Biff]

Try this:

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

Biff

 

[Guest]

Thanks guys. That did it.

John

Try this:

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

Biff

 

[Bernard Liengme]

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

 

[Guest]

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

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