S
SueD
We are running Excel 2000 under Windows XP on 2 different PC's.
In a spreadsheet we have imported data from a text file.
The data has included some nonprintable characters which show up as squares
on my PC but as spaces on my colleagues.
We can use the CLEAN function to strip out the squares, but how do we get
them displayed as squares on the second PC, so that we know that they are
there?
In a spreadsheet we have imported data from a text file.
The data has included some nonprintable characters which show up as squares
on my PC but as spaces on my colleagues.
We can use the CLEAN function to strip out the squares, but how do we get
them displayed as squares on the second PC, so that we know that they are
there?