Format cells

Hello All

Does anyone know if possible and how to do the following:
I have ean barcodes that have spaces in the number, which then can not be uploaded. Is there a way of removing spaces from a string of cells, without manually deleting each space?
As I have hundreds to correct, a solution could save me a huge amount of time.

Thanks in advance
John

if u only have bar codes on that sheet, the easiest way to do it is:

Find and Replace....click on replace command and just hit spacebar in find box and leave replace as is - do replace all and the space between bar codes will be removed.

Thanks

I do the same.