Select the import, do editreplace, put the cursor in the find what box, hold
down alt key while typing 010 on the numeric keypad, release alt key; Leave
replace with blank or put a space there, click replace all.


Regards,

Peo Sjoblom

"frank" wrote:

i am downloading data from a program and pasting it to
EXCEL. there are times when in certain cells a small box
appears which I believe represents a space or who is ever
entering the data hitting ENTER. Is there a way to
remove this from all the cells?