greetings,
Here is what I have. I import a rather large file, not in number of rows (usually 700-800), but in the number of Cols (245) The way the file is generated, if the information being gathered is “empty” they embed one (1) space. Now, I cannot change the way they create the file so, what I am looking for is to have a macro to find the cell(s) that contain the condition where the Cell ONLY contains 1 space, then remove the space.
There would be no other data in the cell. Just the one space.
Thoughts?
Thanks,
Brad
