Removing Spaces Between Names

[Fritz24]

I have a data table that contains employee names. For some reason the source data my table comes from now contains a number of spaces between the firstname and surname of the employees. There is no way I can change this source data.

Is there any way I can replace all the incorrect names with correct ones?

For example:

John Smith = Correct
John____________________Smith = Incorrect (I had to use underscores to illustrate the point - it's spaces in my table)

The number of spaces between the names varies.

Thanks...

 

[Joe4]

I helped out someone with this exact problem before. See:
http://www.mrexcel.com/board2/viewtopic.php?t=83010

 

[Norie]

How about the following

CorrectName:Left([MyField], InStr([MyField], " ")) & Trim(Mid([MyField], InStr([MyField], " ")))

Replace MyField with the appropriate field name.

 

[Fritz24]

That works perfectly Norie - thanks very much