Hi,

Am Sun, 5 Feb 2017 15:45:17 -0800 (PST) schrieb
:

I have absolutely NO experience with excel, and I am trying to sort lot numbers which are followed by a letter; eg:

1B
5B
19B
45B
190B
247B
560B

However I can only sort so it renders my results

1B
19B
190B
247B
45B
5B
560B

if your values in column A then make a helper column with this formula:
=IF(CODE(RIGHT(A1,1)) 64,LEFT(A1,LEN(A1)-1)*1000+CODE(RIGHT(LOWER(A1),1)),A1*1000)
and copy down. Then sort your table by the helper column.


Regards
Claus B.
--
Windows10
Office 2016