Trim "Blank" Cells

[PARans]

I have some blank cells in a worksheet where I would like to enter zeros. A simple find replace doesn't work since excel doesn't see them as blank. I have discovered that there are spaces in the cells so I am thinking a TRIM fuction would work but I don't know how to apply it to a specific range.

Range(Cells(2, 6), Cells(lastrow, 6)).Select

How would I find cells in a specific range that appear to be blank and then replace each with 0?

Thanks!

 

[VoG]

Try selecting the range then running the TrimAll macro http://dmcritchie.mvps.org/excel/join.htm

 

[Jon von der Heyden]

Do they contain a single space only? If so:

Invoke Find & Replace (control+H)
Find: _ (where _ is a space character)
Replace: 0

In options check 'Match entire cell contents'

Hit Replace All

 

[PARans]

No, there are several spaces.

 

[PARans]

Thank you all!

Peter, I used the Remove all Spaces example and then replaced all "" with "0". Spot on! Thanks!