• WORD PROGRAM QUESTION

    From Roger@21:1/5 to All on Wed Sep 11 05:27:43 2024
    Okay a question here if anyone can help

    I use Word program for my listings. Each listing consists of hundreds of consecutively numbered items in proper sequence.

    Is there some kind of program (or addition to Word) that will
    automatically RE-NUMBER said listing in correct sequence if I make any
    kind of alteration,deletion or substitution?

    Remember this is ME we are talking about here :)

    Please keep it as simple as possible

    Thanks!

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From RWC@21:1/5 to All on Wed Sep 11 05:42:16 2024
    On Wed, 11 Sep 2024 05:27:43 +0000, mariabus@blueyonder.co.uk (Roger)
    wrote:

    Okay a question here if anyone can help

    I use Word program for my listings. Each listing consists of hundreds of >consecutively numbered items in proper sequence.

    Is there some kind of program (or addition to Word) that will
    automatically RE-NUMBER said listing in correct sequence if I make any
    kind of alteration,deletion or substitution?

    Remember this is ME we are talking about here :)

    Please keep it as simple as possible

    Thanks!

    MS Copilot is brilliant for any question on how to achieve
    an objective using a MS program such as Word (or Excel).

    I asked, on your behalf:

    I'd like to use Word's auto numbering but how can I first quickly
    delete the current manual numbering?

    Response (which I've expanded upon in places):

    You can quickly remove manual numbering in Word by following these
    steps:

    1. **Select the Text**: Highlight the entire list or the portion of
    the text where you want to remove the manual numbering.
    (note, Ctrl A will highlight all the text in a document)

    2. **Use the Replace Function**:
    - Press Ctrl H to open the Replace dialog box.
    - In the **Find what** field, type '^#. ' (without quotes)
    (# represents any number, and it's assumed numbers are followed by a
    dot and a space - change these Find characters if your list is
    formatted differently).
    - Leave the **Replace with** field empty.
    - Click on **Replace All**. This will remove all manual numbers
    from the selected text.

    3. **Apply Automatic Numbering**:
    - With the text still selected, go to the **Home tab**.
    - Click on the **Numbering icon** in the Paragraph group to apply
    automatic numbering. (first line of small 3-line Numbering icon looks
    like: 1 -----)

    This method should help you quickly transition from manual to
    automatic numbering. If you need further assistance, feel free to ask!

    Roger, with automatic numbering in place, if you delete, insert or add
    lines then the whole list will automatically re-number itself.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Roger@21:1/5 to RWC on Wed Sep 11 13:57:02 2024
    On Wed, 11 Sep 2024 9:42:16 +0000, RWC wrote:

    On Wed, 11 Sep 2024 05:27:43 +0000, mariabus@blueyonder.co.uk (Roger)
    wrote:

    Okay a question here if anyone can help

    I use Word program for my listings. Each listing consists of hundreds of >>consecutively numbered items in proper sequence.

    Is there some kind of program (or addition to Word) that will
    automatically RE-NUMBER said listing in correct sequence if I make any
    kind of alteration,deletion or substitution?

    Remember this is ME we are talking about here :)

    Please keep it as simple as possible

    Thanks!

    MS Copilot is brilliant for any question on how to achieve
    an objective using a MS program such as Word (or Excel).

    I asked, on your behalf:

    I'd like to use Word's auto numbering but how can I first quickly
    delete the current manual numbering?

    Response (which I've expanded upon in places):

    You can quickly remove manual numbering in Word by following these
    steps:

    1. **Select the Text**: Highlight the entire list or the portion of
    the text where you want to remove the manual numbering.
    (note, Ctrl A will highlight all the text in a document)

    2. **Use the Replace Function**:
    - Press Ctrl H to open the Replace dialog box.
    - In the **Find what** field, type '^#. ' (without quotes)
    (# represents any number, and it's assumed numbers are followed by a
    dot and a space - change these Find characters if your list is
    formatted differently).
    - Leave the **Replace with** field empty.
    - Click on **Replace All**. This will remove all manual numbers
    from the selected text.

    3. **Apply Automatic Numbering**:
    - With the text still selected, go to the **Home tab**.
    - Click on the **Numbering icon** in the Paragraph group to apply automatic numbering. (first line of small 3-line Numbering icon looks
    like: 1 -----)

    This method should help you quickly transition from manual to
    automatic numbering. If you need further assistance, feel free to ask!

    Roger, with automatic numbering in place, if you delete, insert or add
    lines then the whole list will automatically re-number itself.

    Wonderful!!

    Many thanks Geoff

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From RWC@21:1/5 to All on Wed Sep 11 12:45:18 2024
    On Wed, 11 Sep 2024 13:57:02 +0000, mariabus@blueyonder.co.uk (Roger)
    wrote:
    On Wed, 11 Sep 2024 9:42:16 +0000, RWC wrote:

    Roger, with automatic numbering in place, if you delete, insert or add
    lines then the whole list will automatically re-number itself.

    Wonderful!!

    Many thanks Geoff

    Thanks for the feedback, Roger.

    I wonder if Bruce has been using automatic numbering
    for his many lists - if not, he might have been reluctant
    to make changes (apart from appending additions)...?

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Steve Mc@21:1/5 to RWC on Wed Sep 11 11:44:37 2024
    On 9/11/2024 2:42 AM, RWC wrote:
    In the **Find what** field, type '^#. ' (without quotes)

    Geoff,

    I familiar with the replace function, but use it primarily in Excel.

    However, I did not know about this guy ->  ^.

    I tried it in Word, and it worked great.

    However, I also tried replacing numbers in Excel with the above ^#, but
    it  did not replace my existing numbers.

    Does this method work in Excel ?

    Thanks,

    --
    Steve Mc

    DNA to SBC to respond

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From RWC@21:1/5 to stevemc209@sbcglobal.net on Wed Sep 11 16:55:38 2024
    On Wed, 11 Sep 2024 11:44:37 -0700, Steve Mc
    <stevemc209@sbcglobal.net> wrote:

    On 9/11/2024 2:42 AM, RWC wrote:
    In the **Find what** field, type '^#. ' (without quotes)

    Geoff,

    I familiar with the replace function, but use it primarily in Excel.

    However, I did not know about this guy ->á ^.

    I tried it in Word, and it worked great.

    However, I also tried replacing numbers in Excel with the above ^#, but
    itá did not replace my existing numbers.

    Does this method work in Excel ?

    No, Steve, this ^# method will not work in Excel.

    By the way, '^' means start matching at the beginning of each line.

    You likely know this already, but sticking with Find and Replace (as
    distinct from using any other method such as formulas or
    VB code) the only wildcards available in Excel are:

    Asterisk (*): Represents any number of characters. For example, *1
    will find any text ending in "1".

    Question Mark (?): Represents any single character. For example, 1?
    will find "10", "11", "1a", etc.

    If, for example, the column is in the format: <number>. <text>
    then I guess Find '*. ' would work.

    I'd be happy to clarify, or address any follow-up questions (not
    involving VB code :)

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Roger@21:1/5 to Roger on Thu Sep 12 14:38:23 2024
    On Wed, 11 Sep 2024 13:57:02 +0000, Roger wrote:

    On Wed, 11 Sep 2024 9:42:16 +0000, RWC wrote:

    On Wed, 11 Sep 2024 05:27:43 +0000, mariabus@blueyonder.co.uk (Roger)
    wrote:

    Okay a question here if anyone can help

    I use Word program for my listings. Each listing consists of hundreds of >>>consecutively numbered items in proper sequence.

    Is there some kind of program (or addition to Word) that will >>>automatically RE-NUMBER said listing in correct sequence if I make any >>>kind of alteration,deletion or substitution?

    This method should help you quickly transition from manual to
    automatic numbering. If you need further assistance, feel free to ask!

    Works good except for this one anomaly when I reach 1000 in the listing

    998. Do You Know What I Mean Hummers (unreleased)
    999. Bobby Jean Andre Williams & Don Juans
    1000. Bless Her Heart Chuck Willis (unreleased)
    1001. Rockin’ Up A Storm Boyd Bennett & Rockets
    etc etc (all following this change in layout)

    Amny ideas?

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From RWC@21:1/5 to All on Thu Sep 12 12:12:40 2024
    On Thu, 12 Sep 2024 14:38:23 +0000, mariabus@blueyonder.co.uk (Roger)
    wrote:

    Works good except for this one anomaly when I reach 1000 in the listing

    998. Do You Know What I Mean Hummers (unreleased)
    999. Bobby Jean Andre Williams & Don Juans
    1000. Bless Her Heart Chuck Willis (unreleased) >1001. RockinÆ Up A Storm Boyd Bennett & Rockets
    etc etc (all following this change in layout)

    Any ideas?

    (I'm going to assume the lines in the message above faithfully reflect
    the character by character content of your Word document - I'm
    thinking of the tab and space characters)

    for 998 to 1001 I don't know what the text (including tabs and spaces)
    was immediately before the auto numbering was applied - was it simply:

    Do You Know What I Mean Hummers (unreleased)
    Bobby Jean Andre Williams & Don Juans
    Bless Her Heart Chuck Willis (unreleased)
    Rockin' Up A Storm Boyd Bennett & Rockets

    Anyway, a quick and dirty solution is to simply remove 8 space
    characters from each line - space characters only start appearing, it
    seems, from 1000 onwards, so the following procedure will not
    affect 1 to 999.

    . press Ctrl H for Find and Replace
    . type 8 spaces in Find what:
    . Replace with: <blank>
    . click on Replace All

    (if you don't highlight any part of the document I think Word
    assumes that any Find and Replace is to be applied to the
    whole document - otherwise, press Ctrl A as a first step)

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Bruce@21:1/5 to All on Thu Sep 12 20:51:21 2024
    I would guess it's the fact that you have..

    999
    1000

    instead of
    999
    1000

    Do you have

    99
    100

    OR

    99
    100

    as you go from 2 digits to 3 digits?

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Roger@21:1/5 to Bruce on Fri Sep 13 05:41:56 2024
    On Thu, 12 Sep 2024 20:51:21 +0000, Bruce wrote:

    I would guess it's the fact that you have..

    999
    1000

    instead of
    999
    1000

    Do you have

    99
    100

    OR

    99
    100

    as you go from 2 digits to 3 digits?

    Yes,I wondered if this might be the reason too

    It jumps from 9 to 10 OK and from 99 to 100 ok

    But as you correctly guessed I indeed have my lists as

    999
    1000

    and that's the one that presents the problem I described

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Rick Schubert@21:1/5 to Roger on Thu Sep 12 23:08:27 2024
    On Fri, 13 Sep 2024 05:41:56 +0000, mariabus@blueyonder.co.uk (Roger) wrote:

    On Thu, 12 Sep 2024 20:51:21 +0000, Bruce wrote:

    I would guess it's the fact that you have..

    999
    1000

    instead of
    999
    1000

    Do you have

    99
    100

    OR

    99
    100

    as you go from 2 digits to 3 digits?

    Yes,I wondered if this might be the reason too

    It jumps from 9 to 10 OK and from 99 to 100 ok

    But as you correctly guessed I indeed have my lists as

    999
    1000

    and that's the one that presents the problem I described

    Roger, you might consider converting this to a table. The ranking number would be in the first
    column, the title in the second, and the artist in the third. Then everything would line up
    properly.

    You might have to remove the rankings first, insert a table over the artists and title, then add
    the rankings back in. Make sure you have a backup copy or can use Undo in case things get messed
    up.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Roger@21:1/5 to Rick Schubert on Fri Sep 13 19:55:07 2024
    On Fri, 13 Sep 2024 6:08:27 +0000, Rick Schubert wrote:

    On Fri, 13 Sep 2024 05:41:56 +0000, mariabus@blueyonder.co.uk (Roger)
    wrote:

    On Thu, 12 Sep 2024 20:51:21 +0000, Bruce wrote:

    I would guess it's the fact that you have..

    999
    1000

    instead of
    999
    1000

    Do you have

    99
    100

    OR

    99
    100

    as you go from 2 digits to 3 digits?

    Yes,I wondered if this might be the reason too

    It jumps from 9 to 10 OK and from 99 to 100 ok

    But as you correctly guessed I indeed have my lists as

    999
    1000

    and that's the one that presents the problem I described

    Roger, you might consider converting this to a table. The ranking
    number would be in the first
    column, the title in the second, and the artist in the third. Then everything would line up
    properly.

    You might have to remove the rankings first, insert a table over the
    artists and title, then add
    the rankings back in. Make sure you have a backup copy or can use Undo
    in case things get messed
    up.

    Thanks Rick,I'm giving myself a permanent headache at the moment trying
    to work out the best (i.e easiest)
    solution to this problem :)

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From RWC@21:1/5 to All on Fri Sep 13 19:06:11 2024
    On Fri, 13 Sep 2024 19:55:07 +0000, mariabus@blueyonder.co.uk (Roger)
    wrote:

    On Fri, 13 Sep 2024 6:08:27 +0000, Rick Schubert wrote:

    On Fri, 13 Sep 2024 05:41:56 +0000, mariabus@blueyonder.co.uk (Roger)
    wrote:

    On Thu, 12 Sep 2024 20:51:21 +0000, Bruce wrote:

    I would guess it's the fact that you have..

    999
    1000

    instead of
    999
    1000

    Do you have

    99
    100

    OR

    99
    100

    as you go from 2 digits to 3 digits?

    Yes,I wondered if this might be the reason too

    It jumps from 9 to 10 OK and from 99 to 100 ok

    But as you correctly guessed I indeed have my lists as

    999
    1000

    and that's the one that presents the problem I described

    Roger, you might consider converting this to a table. The ranking
    number would be in the first
    column, the title in the second, and the artist in the third. Then
    everything would line up
    properly.

    You might have to remove the rankings first, insert a table over the
    artists and title, then add
    the rankings back in. Make sure you have a backup copy or can use Undo
    in case things get messed
    up.

    Thanks Rick,I'm giving myself a permanent headache at the moment trying
    to work out the best (i.e easiest)
    solution to this problem :)

    Roger, I suggest you copy and post here a good chunk of a ranking list
    from a Word document of yours, that includes rankings surrounding the
    1000 mark, that existed before any attempt was made to convert it to
    automatic numbering.

    For instance, a list of songs ranked 900 to 1100, or better still, the
    complete list - as it was, say, a week ago.

    Then, one set of instructions can be proffered that will give you a
    uniform format, with automatic numbering, that does not change at 1000.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)