Sorting The Text and Combine together

[jimmy1975]

Dear All Excel Expert,

I need a help for the below to combine the 4 column (Text) to Single Column Text with Sorting ( Ascending )

Thanks a the help. Sample below : How to use formula to create result at "Sorting Result"



[TABLE="width: 590"]
<colgroup><col><col span="3"><col><col></colgroup><tbody>[TR]
[TD]Result 1[/TD]
[TD]Result 2[/TD]
[TD]Result 3[/TD]
[TD]Result 4[/TD]
[TD][/TD]
[TD]Sorting Result I want[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]B1[/TD]
[TD]C2[/TD]
[TD]A2[/TD]
[TD][/TD]
[TD]A1A2B1C2[/TD]
[/TR]
[TR]
[TD]D2[/TD]
[TD]E2[/TD]
[TD]B2[/TD]
[TD]E1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]D1[/TD]
[TD]C1[/TD]
[TD]D1[/TD]
[TD]A2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]E1[/TD]
[TD]A1[/TD]
[TD]E1[/TD]
[TD]A1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD]E2[/TD]
[TD]A2[/TD]
[TD]E2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C1[/TD]
[TD]C1[/TD]
[TD]D2[/TD]
[TD]E2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]E2[/TD]
[TD]E1[/TD]
[TD]C2[/TD]
[TD]E1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C1[/TD]
[TD]A1[/TD]
[TD]B2[/TD]
[TD]A1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]D2[/TD]
[TD]D2[/TD]
[TD]C1[/TD]
[TD]B1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]D1[/TD]
[TD]D2[/TD]
[TD]B1[/TD]
[TD]A2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]E1[/TD]
[TD]E1[/TD]
[TD]A1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B1[/TD]
[TD]C2[/TD]
[TD]B1[/TD]
[TD]D1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Warship]

Couldn't do it in one Column but this produces your desired results I think.
This uses Array Formulas in Columns F G H & I
Copy the Formula in F2 minus the brackets "{}"
Paste in Cell press CTRL+SHIFT+ENTER
You can then copy in any usual manner F2 thru to I2 then down as far as needed.

Excel Workbook
	A	B	C	D	E	F	G	H	I
1	Result 1	Result 2	Result 3	Result 4	Sorting Result I Want	*	*	*	*
2	A1	B1	C2	A2	A1A2B1C2	A1	A2	B1	C2
Sheet1

 

[XOR LX]

Hi.

Is that the real data or just some dummy data you knocked up to illustrate your query?

If it is the real data, can you confirm that each entry always consists of a single letter followed by a single digit from 1-9, or possibly including 0?

Regards

 

[jimmy1975]

Dear Warship,

It is a great formula. Thanks many for the help.


I study this formula is use to create analysis changes of number out from 4 digits.

Dear XOR LX


It is 4 digits numbers - 0128 , or 8024 . Is data from 4 Digit gaming.

Thanks a lots for the help.