Given these cels in col A:
IAD:a10-1
IAD:a10-10
IAD:a10-11
IAD:a10-12
IAD:a10-13
IAD:a10-14
IAD:a10-15
IAD:a10-16
IAD:a10-17
IAD:a10-18
IAD:a10-19
IAD:a10-2
IAD:a10-20
IAD:a10-21
IAD:a10-22
IAD:a10-23
IAD:a10-24
IAD:a10-25
IAD:a10-3
IAD:a10-4
IAD:a10-5
IAD:a10-6
IAD:a10-7
IAD:a10-8
IAD:a10-9
IAD:a1-1
IAD:a1-10
IAD:a1-11
IAD:a11-1
IAD:a11-10
IAD:a11-11
When sorted, notice that IAD:a10-1 comes before IAD:a1-1, and IAD:a10-2 comes well after
IAD:a10-1. I need to successfully sort with results:
IAD:a1-1
(thru)
IAD:a1-25
(then)
IAD:a2-1 (thru IAD:a2-25)
(up to)
IAD:a18-1 (thru IAD:a18-25)
I tried to search/replace IAD:a1-1 to IAD:a01-01 (assuming excel expects "01" to be smaller
than "1") with:
search IAD:?1-?1 replace IAD:?01-?01
but the results were "IAD:?01-?01" (with question mark)
How do I accomplish this? I'm a novice, so please be gentle...
IAD:a10-1
IAD:a10-10
IAD:a10-11
IAD:a10-12
IAD:a10-13
IAD:a10-14
IAD:a10-15
IAD:a10-16
IAD:a10-17
IAD:a10-18
IAD:a10-19
IAD:a10-2
IAD:a10-20
IAD:a10-21
IAD:a10-22
IAD:a10-23
IAD:a10-24
IAD:a10-25
IAD:a10-3
IAD:a10-4
IAD:a10-5
IAD:a10-6
IAD:a10-7
IAD:a10-8
IAD:a10-9
IAD:a1-1
IAD:a1-10
IAD:a1-11
IAD:a11-1
IAD:a11-10
IAD:a11-11
When sorted, notice that IAD:a10-1 comes before IAD:a1-1, and IAD:a10-2 comes well after
IAD:a10-1. I need to successfully sort with results:
IAD:a1-1
(thru)
IAD:a1-25
(then)
IAD:a2-1 (thru IAD:a2-25)
(up to)
IAD:a18-1 (thru IAD:a18-25)
I tried to search/replace IAD:a1-1 to IAD:a01-01 (assuming excel expects "01" to be smaller
than "1") with:
search IAD:?1-?1 replace IAD:?01-?01
but the results were "IAD:?01-?01" (with question mark)
How do I accomplish this? I'm a novice, so please be gentle...