Hi!

This *might* work.

From David McRitchie:

http://www.mvps.org/dmcritchie/excel/join.htm#trimall

Biff

"CyndyG" wrote in message
...
I would like to have a command button to run code that would check for
unknown characters in column A. I need to remove the end of file
character
before it is copied to a template. I don't know how many rows to have
searched because data with vary. The data consist of all numbers.