G
Guest
Guest
Hi Excellers,
I copy the following number from WORD to EXCEL. I try to soft its with ascending order. But its seem to be won't work for those number with alphabet. How can I ratify its. Thank you.
For example:
2001
2002
2004
2005
2007
2008
2010
2003-L
2006-O
2009-HK
I copy the following number from WORD to EXCEL. I try to soft its with ascending order. But its seem to be won't work for those number with alphabet. How can I ratify its. Thank you.
For example:
2001
2002
2004
2005
2007
2008
2010
2003-L
2006-O
2009-HK