Tuesday, May 31, 2005

MS Excel tricks

If you have a column that has some values and some blanks, if you would like to replace the blanks with something like "n/a," select the column and find/replace nothing with "n/a."

Also, if you have some Word or text documents that have some sort of structure, it's easy to paste text into a text editor, and then do various find/replaces, manual changes, and execute scripts on the text to get it into spreadsheet format.

No comments: