How do I get rid of squares substituting as spaces in excel?
G Gord Dibben Oct 15, 2007 #3 Do you want to get rid of the squares and leave a space where a square was? BTW..........the squares are linefeeds. Edit>Replace What: CTRL + j With: <space> Replace all. To just get rid of the squares see John's relpy. Gord Dibben MS Excel MVP
Do you want to get rid of the squares and leave a space where a square was? BTW..........the squares are linefeeds. Edit>Replace What: CTRL + j With: <space> Replace all. To just get rid of the squares see John's relpy. Gord Dibben MS Excel MVP