# Thread: Formatting converting glossary words into table

1. ## 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

thank you

lilly

2. 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

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

lilly (2016-05-15)

4. 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

#### Posting Permissions

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