Oops, one more thing... if the field does NOT have an extra paragraph
marker, then the replace command is also adding an "*" at the end of
each field. Any way I can get it to stop doing that as well?

thanks, Tanya

In article <1180043650.603503.247090 (AT) q75g2000hsh (DOT) googlegroups.com>,
Tanya Nahman <tnahman (AT) gmail (DOT) com> wrote:

The easiest way to fix both problems is change the calculation used in
the Replace window to something like:

Substitute(
Substitute(
OriginalField & "**",
"{ret}**",
""
),
"**",
""
)

This uses nested Substitute functions - the inner one replaces the
annoying extra Return and appended "**" to a 'nothing', while the outer
one replaces any left over "**" to nothing.

I changed it to use a double "**" since hopefully is less likely to
appear within the field's data itself than a single "*" is. If you are
using possibly double "**" in some of the field's data, then you can
use anything you like that is not in the data: eg. "*-*", ".*.", etc.

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)