When completing an Excel spreadsheet you can be left with odd boxes cluttering up the cells. A simple formula deletes these so that what you see is what you get
Sometimes when text is pasted into an Excel spreadsheet it can contain unprintable characters displayed as small squares.
However, there is a function to remove these characters. To convert text in cell a1, enter the formula =CLEAN(A1) in another cell. The formula can be copied by clicking and dragging on the small black square on the bottom right corner of the cell.
To insert the pure text rather than leaving it as a formula, copy the cells with the formula, right-click in the new position, select Values and then OK. The original cells can be deleted.
Pat H, Computeractive forums
Article tags
Related articles
Q.Why are some of the keys on my keyboard doing strange...
Q.Is my phone’s Bluetooth any use?
Q.Can I switch boot drives so that I can work on older...
A 'small British village' in the mid-Atlantic is in need of funding to get it connected
|
|
|
|
|
Computeractive Excel (2010) Online tutorialPrice: £19.99 |
Computeractive Word (2010) Online TutorialPrice: £19.99 |
Computeractive Powerpoint (2010) Online TutorialPrice: £19.99 |
Angry BirdsPrice: £9.99 |
Back Issue CD-Rom 14 (2011)Price: £15.99 |