I wish I knew about this feature in college. Here’s the problem: You are writing one part of a word document but need to look at the content of another. Say, you are writing the abstract and are plucking relevant parts from the intro, methods, results, and discussion sections. Or, you are writing the results …

Continue reading “Opening the same MS Word document in a second window — the feature that you never knew you wanted.”

Stata’s great at taking raw numbers and chugging out graphs with minimal edits. Often times you’ll get results that aren’t raw numbers, but instead will exist as a string. Instead, of getting: …you’ll get My previous strategy has been to manually extract these numbers into rows and columns. I just came across these two pages …

Continue reading “Extracting numbers from strings in Excel”