Prevent fraction from being converted to decimal

[DougStroud]

I am using a concatenation formula to join several cells. One of which contains sizing, which can be whole, fraction or decimal values. The formula:
=TRIM(CONCATENATE(E67&" "&G67&" "&I67&" "&P67&" "&J67&" "&L67&" "&K67&" "&O67&" "&M67&LEFT(R67,5)&" "&N67&" "&U67))

is converting the fraction value to a decimal, how do I prevent this and maintain the fraction value?

Thanks,

ds

 

[RalphA]

Tell us what, exactly, you have in each of the cell you are using in your formula, and what you expect the final result to be.

 

[DougStroud]

Hi Ralph,
It is very straight forward. All the cells are text items except for "N" which could be 7 1/2 or 7 3/8 which gets converted to 7.5 or 7.125. I want to prevent this conversion from occurring and maintain the fractional values.
Is this clearer?

thanks,

ds

 

[RalphA]

Yes, I see your point. The only way I could find that worked for me was to enter the value 7 1/2 as ="7 1/2"

 

[Peter_SSs]

Doug

See if this simple example helps.
A1: Text entry
B1: 7.5 (entered as a formula just so you could see that it is actually 7.5 not text). B1 is formatted as a fraction.
C1: =A1&" "&TEXT(B1, "# ?/?")
Depending on your fraction values, you may need to tweak the text format in this formula.

Mr Excel.xls
	A	B	C	D
1	Height	7 1/2	Height 7 1/2
2
Concatenate Fraction