Oct 6, 2012
In Word, selecting some text and pressing Shift+F3 will change the case of the selected text. It works on a cycle through the following – lower case , CAPITALS or Sentence Case. Excel does not have this feature but you can use a function to change the case of...
Jun 6, 2012
**Download this tutorial (zipped PDF)** A common problem that many people have is where they have a spreadsheet where data in a single column needs to be split into multiple columns. For example a list of employee names where both First Name and Surname are in the...
