|  | Sorting Paragraph number convention | | |
| | | 2GWLAN |  |
|  Posted: Thu Jul 10, 2008 5:57 pm Post subject: Sorting Paragraph number convention |  |
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 |
| |
| | | AltaEgo | |
| | Posted: Thu Jul 10, 2008 9:44 pm Post subject: Re: Sorting Paragraph number convention | |
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.
--
Steve
"2GWLAN" <2GWLAN@discussions.microsoft.com> wrote in message
news:CE86684F-01C0-425E-8B0F-40F75A41C1AC@microsoft.com...
| Quote: | 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
|
|
| |
|
|
