Concatenating decimal numbers and character to display fractions in another cell.

[Joek88]

Hi all,

I am having some trouble trying to fix an issue I have with excel. Below in the BLUE outlined cells, I have a conctenation formula to combine the following to where the red arrow points. It works as planned! No problems, and this is the formula I use to make this happen:

=IF(ISBLANK(C4),"",CONCAT(C4,"-",E4,"-",F4,"-",G4,"-",H4,"-",I4))

Now, I want the cell in K5 to also concatenate the information from cells D4-J4 and put them into the format below in green. For some reason, the 0.75 is not changing to 3/4" and the 1 needs to change to 1". The highlighted green K5 is what I want the formula to spit out. (I just manually entered it to show what I want it to do.) How can I achieve this?

Thanks!

 

[JamesCanale]

MrExcelPlayground19.xlsx
	D	E	F	G	H	I	J	K
2	3/4''	Vacuum Condesate	1005	9scna	H	1	1''	3/4''-Vacuum Condesate-1005-9scna-H-1''
Sheet31

Cell Formulas
Range	Formula
K2	K2	=TEXT(D2,"# #/#''")&"-"&E2&"-"&F2&"-"&G2&"-"&H2&"-"&TEXT(I2,"# #/#''")

 

[Bosquedeguate]

Try this formula
=D5&"-"&E5&"-"&F5&"-"&G5&"-"&H5&"-"&J5

KWHSplit.xlsx
	D	E	F	G	H	I	J	K	L	M	N	O
5	3/4"	VACUUM CONDENSATE	1005	9SCNA	H	1	1"	3/4"-VACUUM CONDENSATE-1005-9SCNA-H -1"
Split Table

Cell Formulas
Range	Formula
K5	K5	=D5&"-"&E5&"-"&F5&"-"&G5&"-"&H5&"-"&J5

 

[Joek88]

MrExcelPlayground19.xlsx
	D	E	F	G	H	I	J	K
2	3/4''	Vacuum Condesate	1005	9scna	H	1	1''	3/4''-Vacuum Condesate-1005-9scna-H-1''
Sheet31

Cell Formulas
Range	Formula
K2	K2	=TEXT(D2,"# #/#''")&"-"&E2&"-"&F2&"-"&G2&"-"&H2&"-"&TEXT(I2,"# #/#''")

This worked! Thank so much James, you've save me so much time!