Order columns with text and numbers

[FioreMatto]

Good morning
in the file attached from A2 to B10 we have numbers and letters the purpose is to sort the numbers in ascending order and the letters in alphabetical order in column D
without VBA
Thanks for your attention

[Glenn Kennedy]

Can there be duplicates? If so, do you want both of them returned?

[AlKey]

You may need to replace commas with semi:colon

Enter formula in D2 and copy down

Please Login or Register  to view this content.

v	A	B	C	D
1
2	8	D		1
3	C	3		2
4	7	E		3
5	10	2		4
6	F	A		5
7	1	G		6
8	5	H		7
9	6	4		8
10	B	9		9
11				10
12				A
13				B
14				C
15				D
16				E
17				F
18				G
19				H

[FioreMatto]

Thank you
it works perfectly

[FioreMatto]

Good morning
testing the proposed formula only works for the example posted since regardless of the letters it always returns the sequence A, B, etc
I've lost some time and I've come to this solution that works properly

=IFERROR(SMALL($A$2:$B$10,ROW(A1)),CHAR(AGGREGATE(15,6,((CODE($A$2:$B$10)>=65)*(CODE($A$2:$B$10)<=90))*CODE($A$2:$B$10),ROW(A1))))

[Glenn Kennedy]

Do bear in mind that solutions offered are only as good as the sample provided. It's really important to make samples that are TRULY representative of your real data and not just a random sequence of 1-10 and A-J.