tags:

views:

14

answers:

0
Q: 

Excel data sorting

Hi,

How can I sort data containing text and numbers depening on odd and even numbers? example: a1. a03, b2, n08 n9

ans should be: a1,a03,n9 and b2,n08 i want to get separate lists.

Please help. Thank you.

related questions

Setting a cell's format using Excel 2007 Interop and C#
Where should I post my python code?
excel: charting with unknown number of data
Read specific Coloumns from Excel files with C#
add decimal as time
How to display .net automation add-in functions in excel's formula autocomplete
Excel formula to refrence 'CELL TO THE LEFT'
Problems Reading a .xlsx file?
VBA code for SUMIFS?
Accessing Excel 2007 Binary (.xlsb) via OleDb ACE
How can I permanently prevent Excel from setting all new documents to R1C1 mode?
How do get the index of a table's column by using a structured reference in excel?
Can I make a structured reference absolute in excel 07?
Excel countif Pulling apart a cell to do different things
Upgrade from Excel 2003 to 2007 results in "stack overflow error" on previously working vba
System.Windows.Forms.ToolStrip height or autosize
VSTO problem - cannot create visual studio excel workbook project
Round function in Excel, worksheet function vs VBA
Reliable real values generator for Excel for Office 2007 and Vista SP1
Create an Excel workbook on a x64 system
How to import data from Excel 2007 xlsx file into SQL Server 2000 Database?
How do I send an alert to a blackberry from an Excel 2007 spreadsheet?
How to convert a column number (eg. 127) into an excel column (eg. AA)
How do I create an Excel chart that pulls data from multiple sheets?
VSTO Excel 2007 PivotTable, having a PivotField in more than one column