Solved: Sorting Alphanumerics and Extracting numbers from them.

[Prema]

Hi All,
I have some immediate requirements.
Can anyone please tell me how to sort alphanumerics range in Excel. The sort should be, first alphabets to be sorted followed by accordinly the numbers should
be sorted.
For Example,
If I have a alphanumeric range in Excel like below
A
ABC-0010 ABC-0015
CAT-000009
ZIP-00000050
CAT-0000014
MAX-0000003800
ABC-0001
ZIP-00000039
ABC-0007
CAT-000002
MAX-0000003600
ABC-0006
MAX-0000003550
ZIP-00000001
MAX-0000003750
ZIP-00000074
CAT-000021

B
ABC-0015
CAT-0000015
ZIP-00000075
CAT-000020
MAX-0000003900
ABC-0005
ZIP-00000045
ABC-0009
CAT-0000008
MAX-0000003700
ABC-0006
MAX-0000003599
ZIP-00000038
MAX-0000003799
ZIP-00000080
CAT-000030



The above columns should be sorted just like shown below,Where column A contains start of the range and column B contains End of the range. And both of the columns should be
sorted at a time.

A

ABC-0001 ABC-0005
ABC-0006
ABC-0007
ABC-0010
CAT-000002
CAT-000009
CAT-000014
CAT-000021
MAX-0000003550
MAX-0000003600
MAX-0000003750
MAX-0000003800
ZIP-00000001
ZIP-00000039
ZIP-00000050
ZIP-00000074

B

ABC-0005
ABC-0006
ABC-0009
ABC-0015
CAT-000008
CAT-000015
CAT-000020
CAT-000030
MAX-0000003599
MAX-0000003700
MAX-0000003799
MAX-0000003900
ZIP-00000038
ZIP-00000045
ZIP-00000075
ZIP-00000080








If there are spaces, that range should be added at the end of all.And if tcere are decimal numbers it should consider though.

2. How do I extract numbers from alphanumerics, including decimals.

3. How do I return more than one value using functions in VBA?


Using Excel 2007 .

Your immediate reply is highly appeciated.

Thanks,
Prema