|
|
|
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
Sometimes it is useful to be able to see the whole Excel spreadsheet's formulae instead of in a single cell. Here's how to do it with one quick keystroke
Change the information shown in Microsoft Excel 2003's Status bar
A limit to the number or columns and rows in a spreadsheet causes problems
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...
Make a profit from your unused gadgets
Run Windows and Ubuntu on the same computer
Hide private folders
Save up to 40% on the price
Exclusive subscriber website
Our price won't be beaten
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 |
