Combine text from two or more cells into one cell

[Pinaceous]

Hi All,

I'm trying to combine text from two or more cells into one cell.

For example, I want to combine

XYZ 0.21% 6.58% 6.58%

from separate cells into one cell.

I referenced the other cells as

=A312&" "&H312&" "&K312&"  "&L312

but it does not return their percentages forming the result on the far right.


Do you know how I can combine them in respecting their percentages as can be seen here second from the right?

Please let me know.

Thank you!
pinaceous

 

[TomBenz]

=D312&" "&TEXT(H312,"%0.00") use something like this

 

[AhoyNC]

Try:

Book3
	A	B	C	D
1	xyz	0.21%	6.58%	6.58%
2
3		xyz .21% 6.58% 6.58%
Sheet3

Cell Formulas
Range	Formula
B3	B3	=TEXTJOIN(" ",1,TEXT(A1:D1,"#.##%"))

 

[Peter_SSs]

how I can combine them in respecting their percentages as can be seen here second from the right?

I think that you need this slight modification of @AhoyNC's suggestion

24 01 24.xlsm
	A	B	C	D	E	F
1	xyz	0.21%	6.58%	6.58%		xyz 0.21% 6.58% 6.58%
2	abc	3.20%	25.00%	3.25%		abc 3.20% 25.00% 3.25%
TEXTJOIN

Cell Formulas
Range	Formula
F1:F2	F1	=TEXTJOIN(" ",1,TEXT(A1:D1,"0.00%"))

 

[Pinaceous]

I think that you need this slight modification of @AhoyNC's suggestion

24 01 24.xlsm
	A	B	C	D	E	F
1	xyz	0.21%	6.58%	6.58%		xyz 0.21% 6.58% 6.58%
2	abc	3.20%	25.00%	3.25%		abc 3.20% 25.00% 3.25%
TEXTJOIN

Cell Formulas
Range	Formula
F1:F2	F1	=TEXTJOIN(" ",1,TEXT(A1:D1,"0.00%"))

Hey PeterSSs!
Thank you so much

 

[Pinaceous]

Try:

Book3
	A	B	C	D
1	xyz	0.21%	6.58%	6.58%
2
3		xyz .21% 6.58% 6.58%
Sheet3

Cell Formulas
Range	Formula
B3	B3	=TEXTJOIN(" ",1,TEXT(A1:D1,"#.##%"))

Thanks AhoyNC!

 

[Peter_SSs]

You're welcome. Glad we could help. Thanks for the follow-up.