Tuesday, October 24, 2006

Copying Tables from the Internet:

It is observed that many times while copying tables with numbers from Internet or some Databases, the numbers are not useable, in the sense that if you add them no result is found. This happens due to the fact that the data copied also includes some hidden text potion preceding the numbers in each cell that is not visible. What to do? Simple copy hidden text from one cell and do a find the hidden text (Ctrl+H) and replace that text with blank data (Ctrl+V; Ctrl+A)

No comments: