Hello.
I have many part numbes to sort. The problem is that some part numbers are
all numbers, and some part numbers begin with: TE
I'd like to ask Excel to ignore the TE when sorting, and only sort by the
number component, but still keep the TE. Any way to do that? I can do it
VERY clumsily with Text To Columns, but this is for a co-worker little Excel
experience, and the list gets added to daily.

Have this:
198919-001
198960-001
198962-001
TE198580-1
TE198763-7

Need this:
TE198580-1
TE198763-7
198919-001
198960-001
198962-001
TE199014-1

I'd appreciate any suggestion, thanks.