Removing a Space, If There is More Than One

Hi all,

Firstly I would just like to express my frustration with regards to people who's job is data entry. Inconsistencies are very frustrating.

My problem is this: I have to compare dates that come in this format "mmmm yyyy". No problem but as of this month's update, the source has entered their date like this: "October 2010". There are two spaces between November and 2010 instead of the normal one space. Because of this, the code I implemented does not read the cell and skips it entirely. I would prefer the code fix the source error if it exists for consistency's sake. Is it possible to look at a cell and remove an extra space if it exists between two values?

PS. I know we are all human and data entry can be quite tedius and therefore prone to error but from a programming point of view these little inconsistencies are a pain in the behind.

Many thanks