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"

Result 1	Result 2	Result 3	Result 4		Sorting Result I want
A1	B1	C2	A2		A1A2B1C2
D2	E2	B2	E1
D1	C1	D1	A2
E1	A1	E1	A1
A2	E2	A2	E2
C1	C1	D2	E2
E2	E1	C2	E1
C1	A1	B2	A1
D2	D2	C1	B1
D1	D2	B1	A2
A1	E1	E1	A1
B1	C2	B1	D1

<colgroup><col><col span="3"><col><col></colgroup><tbody>
</tbody>

 

[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.