Hello, This is a simple question as to why Excel does what it does dealing with the Replace feature. I have already found a solution on how to remove the spaces between numbers in a cell. The =Substitute(A1," ","") formula worked fine.
What I want to know is why when I removed them using the Replace option, the numbers are all changed. No matter what format I choose the number would change after replacing all the spaces with nothing. This was very frustrating and I am inquiring about this as a way to ease my frustration on this topic. I will include an example of the numbers I am dealing with as well as the working formula. Please try to use the Replace feature and see if your results are any different then these made up numbers it have been giving me.
Please feed me your knowledge.
Thank You!
Bookmarks