B1: =LEN(A1)-LEN(SUBSTITUTE(A1,” “,””)) Notice the space there. You can replace that with any other letter to see how many instances of that character are present. [...]
fn+delete Also, you can do control+B I know, with Excel on Windows it’s easier 🙂 Kudos to ExcelJet for this gem.
I am working on graphs and I need to find the percentage of increase from one figure to another. How do I do that? For instance staff hours for 2006 were 28011 and for 2007 were 31230. How do I [...]
So you’ve gone through setting up WordPress Multisite, and now you’re ready to start setting up new sites in your network. Only trouble is, you want to use unique domains for your sites instead [...]
In High Tech, Microsoft Excel, Microsoft Office, Microsoft Windows, Microsoft Word, Technical SupportPosted
Word 1. CTRL+A and then CTRL+SHIFT+F9 2. Credit to http://www.tech-recipes.com/rx/1323/remove-all-hyperlinks-in-word-or-excel/ Go to “Insert” > “Module” and in the pop-up window copy: Sub [...]
Removing a bunch of hyperlinks can be tedious. Imagine the time you have to spend right-clicking on each of those links and selecting ‘remove hyperlink’ on the context menu. Of course [...]
This has personally worked like a charm for me. Try this user-defined function: =ShowAddress(A1) Where A1 is the cell with the hyperlink in it. Here is the Macro function code: Public Function [...]