Hi
If the cells are "dirty" because they contain spaces, you can remove them by going to
Edit, Replace, in the find-what box enter * then press your spacebar once. The replace-with-what box should be completely blank. You must ensure the box "find entire cells only" is selected. Click Replace All
Hope this helps
regards
Derek
Like this thread? Share it with others