concatenate data problem

[Mike Kiekover]

I have the following formula

=CONCATENATE(B13,AY13,"-",C13,"-",D13,"-",E13,IF(F13="","","-"&G13&AY13&"/"&F13))

to return the following text

2.5"-MS-1302-01CS-1SW-2.5"/ST

the problem is that cells B13 & G13 are formatted as "Fraction" and display 2 1/2, but the formula result displays 2.5

Is there a way to get the formula to display the value as represented in the source cells (ie. 2 1/2"-MS-1302-01CS-1SW-2 1/2"/ST)

Thanks
Mike K

 

[Beege]

I have the following formula

=CONCATENATE(B13,AY13,"-",C13,"-",D13,"-",E13,IF(F13="","","-"&G13&AY13&"/"&F13))

to return the following text

2.5"-MS-1302-01CS-1SW-2.5"/ST

the problem is that cells B13 & G13 are formatted as "Fraction" and
display 2 1/2, but the formula result displays 2.5

Is there a way to get the formula to display the value as represented in
the source cells (ie. 2 1/2"-MS-1302-01CS-1SW-2 1/2"/ST)

Thanks
Mike K

Mike,

Try TEXT(B13,"# ?/2") in your formula

Beege

 

[Ron Coderre]

Try something like this:

=CONCATENATE(TEXT(B13,"#
#/#\"&""""),AY13,"-",C13,"-",D13,"-",E13,IF(F13="","","-"&TEXT(G13,"#
#/#\"&"""")&AY13&"/"""&F13))

or this....

=TEXT(B13,"#
#/#\"&"""")&AY13&"-"&C13&"-"&D13&"-"&E13&IF(F13="","","-"&TEXT(G13,"#
#/#\"&"""")&AY13&"/"&F13)

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP

 

[Mike Kiekover]

Great guys thanks - I just couldn't come up with the way to "format" the
text. "# #/#" is what works for me.

Mike K