Rick,
I think you missed my original post
Jim Cone


"Rick Rothstein"

wrote in message
I know he asked about leading/trailing spaces, but his original question
showed there were commas in front of the spaces that also had to be removed.
In addition, your suggestion would change the text he wants to preserve if
it happens to have multiple internal spaces (for formatting or column
alignment as an example) since TRIM collapses multiple spaces down to single
spaces.
--
Rick (MVP - Excel)