Showing posts with label Clean function. Show all posts
Showing posts with label Clean function. Show all posts

Monday, April 18, 2011

How to remove special characters from Excel cell


Enlarge it to clearly view special character

Whenever you link cell in Excel worksheet to a cell that has multiple lines, you might notice that the linked cell shows text in single line and a tiny suspicious character shows up at the place of line break.