Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    May 2016
    Posts
    12
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Formatting converting glossary words into table

    Hello dear folks,

    I am needing some help on this difficult job.

    I am trying to sort out pages of a glossary and make them into a nice organized table.

    Below is an example:

    Bell Flower, 443–444, 447–451 Canterbury Bells,406 Campanula, 708 Bells of Ireland, 345 Moluccella, 450-123 Bird of paradise, 234 Strelizia, 506 Bleeding Heart, 201 Dicentra spectabilis, 567-578 Bloom,27 Chrysanthemum, 789-799, 233–234 Blue throatwort,345-344,123-124

    My idea is to

    First put them on a new line
    Copy them to Excel, some how split the line

    example

    Bell Flower, 443–444, 447–451

    Glossary Words > Page Number
    Bell Flower > 443–444, 447–451


    First question

    How can I put them on a new line - I will need to split it where the last character is a number followed by a space.

    I have researched for days and I cant find anything that works

    I tried a number of wildcard searches

    [0-9] {6} ^s

    I would appreciate any advice

    thank you

    lilly
    Last edited by lilly; 2016-05-15 at 10:05. Reason: the table did not show on post

  2. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts
    Try a wildcard Find/Replace, where:
    Find = ([a-z])[, ]{1,}([0-9][!A-Z]{1,})
    Replace = \1^t\2^p
    followed by an ordinary Find/Replace, where:
    Find = ^w^p
    Replace = ^p
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  3. The Following User Says Thank You to macropod For This Useful Post:

    lilly (2016-05-15)

  4. #3
    New Lounger
    Join Date
    May 2016
    Posts
    12
    Thanks
    4
    Thanked 0 Times in 0 Posts
    Hello Paul,

    oh my goodness, no wonder I could not find anything on google.

    Find = ([a-z])[, ]{1,}([0-9][!A-Z]{1,})
    Replace = \1^t\2^p

    This is magic!

    And I cant believe it I copied the list to excel and it sorted it like this

    paul.png

    So I am really happy thank you for helping me

    may i leave it open in case i get stuck

    ill pop back

    lilly
    Last edited by lilly; 2016-05-15 at 20:02.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •