Sorting rows in Excel

[ExcelGeek5038]

Hi Team, I wanr to sort my excel in ascending order. I can use simple sort filter smallest to largest but thing is any number like 15A is going at the bottom of the excel and then I have copy paste manual. Can anyone help me sort it? thanks alot

 

[SanjayGMusafir]

Hi Team, I wanr to sort my excel in ascending order. I can use simple sort filter smallest to largest but thing is any number like 15A is going at the bottom of the excel and then I have copy paste manual. Can anyone help me sort it? thanks alot

Leading Zero(s) is the answer

 

[ExcelGeek5038]

Hello Mr Sanjay, thanks for your reply would you mind telling me how would i got about it? I went to custom and 000.000 and sorted still numbers with alphabets in it are sorted at the end? thanks alot

 

[SanjayGMusafir]

still numbers with alphabets in it are sorted at the end

I tried it out. Actually I keep Ids other way round starting with alphabets and then numbers - In that case leading Zero(s) help in right sorting.

But in your case that is also no workable as you would like 25A, 25B, 25C to appear together in order.

The only solution I can think is to keep numbers and alphabets in separate columns and sort them as per the need.

All Records.xlsb
	J	K	L
1	C1	C2	ID
2	26	C	26C
3	28.2		28.2
4	32		32
5	36	A	36A
6	36	C	36C
7	45		45
Sheet4

Cell Formulas
Range	Formula
L2:L7	L2	=J2&K2