concatenate data problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike Kiekover - 24 Apr 2007 04:14 GMT

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

Reply to this Message

Beege - 24 Apr 2007 18:47 GMT

> I have the following formula
>
[quoted text clipped - 12 lines]
> Thanks
> Mike K

Mike,

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

Beege

Reply to this Message

Ron Coderre - 24 Apr 2007 19:02 GMT

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

> > I have the following formula
> >
[quoted text clipped - 18 lines]
>
> Beege

Reply to this Message

Mike Kiekover - 24 Apr 2007 20:30 GMT

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

Mike K

> Try something like this:
>
[quoted text clipped - 38 lines]
>>
>> Beege

Signature

Posted via a free Usenet account from http://www.teranews.com

Reply to this Message

Rate this thread: