Assuming your data is in Col A, use the following formula in another column:
=LEFT(A1,Find(" ",A1)-1)
Copy down. If you want to compeltely replace the data in Col A, then copy>paste special these new values onto Col A.
Give this formula a try (also works if there are not two spaces...returns what's there)...Hi,
I have a similar requirement, but need to delete everything after the 2nd space in a cell.