Sorting Paragraph number convention

  • Thread starter Thread starter 2GWLAN
  • Start date Start date
2

2GWLAN

Excel 2007-
Column 1 is a building # i.e. 105 there are xx rows before the next building
number sequence.

Column 2 is CLIN... should be in the following convention-
1
1.1
1.2.1
2
2.1 Etc...

but instead it is like this
1.3.6
1.3.7
1.4.24
1.4.8
15-1
15-2
15-29
15-3
15-4
15-5
15-6
15-7
2.1.11

Originally this was an access database, but I extracted it because I didn't
like the way the report works...

Thanks,

Phil
 
The answer seems to be to split the components of you chapter number across
different columns using menu Data; Text to columns. Sort by the resulting
columns. Make sure you work with a copy/paste column of your original
numbers so you don't lose them in the conversion.

Find/Replace should fix the intermingling of "," and "-" characters.
 
Back
Top