| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting characters, ignoring numbers
Is it possible to sort this way without using extra columns? For instance I have a spreadsheet with 256 columns and a header row with between 10 and 30 columns that need sorting (ignoring the number at the beginning ... or first 2 characters) below each. I am thinking I will need VBA to do this.
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting data bust ignoring numbers | Excel Discussion (Misc queries) | |||
| Ignoring punctuation when sorting | Excel Discussion (Misc queries) | |||
| Ignoring #N/A in sorting? | Excel Discussion (Misc queries) | |||
| Ignoring characters when sorting | Excel Discussion (Misc queries) | |||
| Ignoring characters in excel sheets when creating a chart | Charts and Charting in Excel | |||
Threaded Mode
