Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-15-2012, 03:00 PM
Opul3nce Opul3nce is offline How to do an alpha numeric Sort By? Windows XP How to do an alpha numeric Sort By? Office 2007
Novice
How to do an alpha numeric Sort By?
 
Join Date: Oct 2012
Posts: 1
Opul3nce is on a distinguished road
Default How to do an alpha numeric Sort By?

Hello,


First and foremost,
I'm new here and would like to say thank you beforehand for any assistance you give.

Here is the problem I've got.

I export DOORS requirements to excel 2007,

The requirements are described as

Code:
 
TEST-1
TEST-34
TEST-24
TEST-100
etc.

When using Excels default A->Z 'sort by' feature I get

Code:
 
TEST-1
TEST-100
TEST-24
TEST-34
Needless to say what I actually want is

Code:
 
TEST-1
TEST-24
TEST-34
TEST-100
I find it interesting that I can type
Code:
 
TEST-1
TEST-2
Then highlight and click and drag to get TEST-1 all the way to TEST-X, yet I can't sort by this way, or at least I don't know how.

Again, Many Thanks!
Reply With Quote
  #2  
Old 10-15-2012, 11:11 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline How to do an alpha numeric Sort By? Windows 7 64bit How to do an alpha numeric Sort By? Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,569
Pecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to behold
Default

I think the easiest way is to use a helper column containing
Code:
=MID(A1,6,LEN(A1)-5)*1
( dragged down) which will give you a column containing the numbers then sort the range by that column. You can eventually hide this helper column
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Tags
column, data, sort

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to do an alpha numeric Sort By? Unique 3 char Alpha Numberic column mauricioaglr Excel 7 03-09-2012 06:45 PM
How to do an alpha numeric Sort By? alt+numeric doesn't work Kungen Word 3 12-02-2011 11:25 AM
How to do an alpha numeric Sort By? Word 2007 TOC Section Number w/Alpha Prefix? Gwen Butler Office 2 09-29-2011 06:10 AM
How to do an alpha numeric Sort By? Place pages in alpha order. Wskip49 Word 5 08-28-2011 07:54 PM
How to do an alpha numeric Sort By? [How To] Generate Alpha Numeric Values in Excel 2010 stnicholas81 Excel 1 07-25-2011 01:31 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:45 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft