The Trim function will get rid of trailing spaces without affecting internal
spaces.

--
Regards,
Fred


"JoeSAT" wrote in message
...
kecause of data entry irregularities, my records look like this:
John Smith 10
John Smithx 12
John Smith 8

When I use PivotTable to sum sales, I get two sums for John Smith. How can
I find and replace the blank space x without removing the space between John
and Smith? Thank you.