I can't duplicate your error. You should have been able to copy it down
without any problem if it worked for the first entry. Another function that
can be used is CLEAN in place of TRIM in the formula. See if that makes any
difference.

"Cthulhu" wrote:

Thank you all for your suggestions.

SauveC--

I did try your suggestion combined with Julie's. It worked perfectly for
the first cell. When I tried to drag the fromula down the rest of the
worksheet, however, I get a "#VALUE" error. Now what? :)