Semi-Automated Parsing word text

I use a mix of Excel & Word for my semi-aumatic parsing.
I import the reference into a single column (FileOpen as
text) and then
use a mixture of the  Data / Text to Columns ... command and
the
functions LEFT(), RIGHT(), and MID(). sometimes use other
functions like
FIND(),
LEN()

Sometimes I copy and paste into Word to get some bits (eg
search and
replace for formatting is easier in Word) It's a toss-up if
it's easier
to just re-type or to parse. Depends on how many there are
and how
different they are.
Sometimes need to sort first, and/or combine following lines
so each
reference is in a single row.
I always add a new column, OriginalOrder, so that I can
return to
original sort order.
I have some macros I use with parsing, but usually the text
is different
enough each time that using functions instead is easier Once
it is
parsed into separate columns, copy and paste it into Word
and use the
mail merge feature to create a tagged list which can then be
imported
into EndNote (into a new temporary library, so you can fix
errors before
they get lost in a 17,000 reference main library)

Ruth Callcott
Callcott Consulting Pty Ltd
Newcastle Australia
(h) 02-4962 1914
(w) 02-4968 3408
ruthcallcott.com.au
ps I have tried sending this before, but it doesn't seem to
end up on
list.