Delete space between words quickly

[smscheung]

If there are more than 100 names in an excel, I would like to delete all the spaces between those names at once, is there a quicker way of doing this instead of manually going into each cell and delete the space?
For Example:
David Beckham --> DavidBeckham

Thanks.

 

[My Aswer Is This]

1.Select the range of cells.
2.On the Ribbon select Find
3.Choose Replace
4.In the Find what box enter a space
5. In the Replace Box leave that empty
6. Choose Replace ALL

 

[smscheung]

1.Select the range of cells.
2.On the Ribbon select Find
3.Choose Replace
4.In the Find what box enter a space
5. In the Replace Box leave that empty
6. Choose Replace ALL

Thanks a lot, can't believe I missed this simple way of doing it.

 

[My Aswer Is This]

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.

Thanks a lot, can't believe I missed this simple way of doing it.