Excel

		Microsoft Office Forums > Microsoft Excel > Excel
Excel

FAQ

Thread Tools

Display Modes

11-10-2017, 02:30 PM

JAYMCK1987 JAYMCK1987 is offline

Windows XP Excel

Office 2016

Novice

Join Date: Nov 2017

Posts: 2

Excel

Is there a way to sort 1 column in excel alapheticly and numerically? This is for a flow in a warehouse. My flow goes 2a1.1, 2a1.2, 2a2.3, 2a3.4, 2a4.3, 2a5.3, 2a6.1, 2a7.3, 2a8.1, 2a9.3 2a10.1 and so on. The problem being when I sort alapheticly I doesn't sort it I the correct order. The order goes a1,a2, a3, a4, a 10, a5, a6, a7,a8, a9 for some odd reason. Can this be fixed. Thanks for you help

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Word & Excel 2010 - Best Options To Auto Insert MySQL & Excel Data?	Hoser	Word	1	03-17-2017 03:47 PM
Embeding Excel Docs in Word - Receiving Memory Error Message if Excel is open	kdash	Word	0	05-06-2015 09:38 AM
How To Open an Macro From 2003 Excel in 2013 Excel Spread Sheet?	ADubin	Excel Programming	3	02-08-2015 04:57 AM
[Excel 2007] Building Power Point Slides from data in an Excel Table	bremen22	Excel Programming	1	08-07-2013 11:01 AM
Excel 2011 can't open old Excel 98 or Excel X files	FLJohnson	Excel	8	05-09-2012 11:26 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:14 PM.