Delete spaces from Rows

[A Prince]

Is there a way to delete spaces between numbers automatically by rows? Someone inputted about 300 rows of numbers, but placed spaces between each 5 number block. I need them as one solid number in order for a different form to find the correct entry. Obviously I can do each one individually but was just wondering if there was a way to do it automatically.

Thanks

 

[bbott]

Select the column with the entries and do a find and replace:

Find What: type a space
Replace With: leave blank

 

[A Prince]

Thanks!!

I just hate my "Duh" moments...lol

Select the column with the entries and do a find and replace:

Find What: type a space
Replace With: leave blank

 

[bbott]

Thanks!!

I just hate my "Duh" moments...lol

You're welcome.