Macro to "separate" entries in a field?

[StargateFan]

A quick example of two "records" in a sheet full of similarly
structured records. The first line in each is the title, the second a
set of keywords related to the title above it (and the numbers = page
numbers):

(Topic) Big Bang Nucleosynthesis 5
(Keywords) baryogenesis 5, hydrogen 6, primordial nucleosynthesis 6

(Topic) Planetary Nebula 1
(Keywords) Milky Way Galaxy 1, ionized gas 2

----------------------------------------

Is there a way to have a source sheet that contains many entries
entered in the above style, or whatever works best to achieve results,
output to something like this index below?

----------------------------------------

B
baryogenesis 5 (Big Bang Nucleosynthesis, 5)
Big Bang Nucleosynthesis, 5

H
hydrogen 6 (Big Bang Nucleosynthesis, 5)

I
ionized gas 2 (Planetary Nebula, 1)

M
Milky Way Galaxy 1 (Planetary Nebula, 1)

P
Planetary Nebula, 1
primordial nucleosynthesis 6 (Big Bang Nucleosynthesis, 5)

----------------------------------------

The really necessary automation would be required for breaking up the
keywords, so if the entire process above would involve too complex a
macro, at least, if there would be a way to separate the keywords,
that would still be really, really good. I could then try to figure
out a way to automate sorting everything alphabeticallly afterwards.
The breakdown is what would be wonderful to automate since that's what
takes hours of work.

The index is required for books that are not digitized, that is why
I'm trying to find a software solution. There is actually software
that supposedly creates an index for electronic books but that doesn't
help here <g>.

Does anyone know of code that could do this? Thanks.

 

[Don Guillett]

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.