shg: just tried that and didn't seem to work ... maybe doing something wrong (although your directions were pretty simple)

1) copy a blank cell
2) then select all the cells with leading space
3) choose paste special with "add" selected

am I missing something ... when I do this nothing seems to happen