I have many cells where the numbers have a space or two after each one. I am
not able to format them as numbers because of this and don't want to have to
remove them manually. I have tried the Replace with but don't know how to
have it remove spaces. It says I must have a value.
Thanks.