concatenate data problem

M

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
 
B

Beege

Mike said:
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
 
R

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
 
M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top