Microsoft Office

Microsoft Excel: How to Count Number of Spaces in Cell String

388 321 rhecht

excel

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. It’s simple and genius.

Excel on Mac – How to Delete Contents of Multiple Cells

256 256 rhecht

excel_logo

fn+delete

Also, you can do control+B

I know, with¬†Excel on Windows it’s easier ūüôā

Kudos to ExcelJet for this gem.

Excel – How to Remove Multiple Hyperlinks by Using a Macro

150 150 rhecht

excel_logoI’ve seen many other places on the internet where an item doesn’t show up, requires a plugin, or that the version of Microsoft Office isn’t compatible. This macro solution actually works.

Step 1. Press Alt + F11 to start the Visual Basic Editor.

Step 2. Double click the workbook you are using on the Project Explorer and type the following code:

Sub RemoveHyperlinks() 
ActiveSheet.Hyperlinks.Delete 
End Sub

Step 3.¬†Save your work. Note: if you’re using Excel 2007 or higher it may ask you to save the workbook as .xlsm. If this is only a one-time thing you should just save your workbook “as is.”

Step 4. Run the macro by pressing Alt + F8 or using the menu by View > Macros

Step 5.¬†Select the macro you have made, it should have the name ‚ÄėRemoveHyperlinks‚Äô.

How to Recover a Lost ASD File in Microsoft Word 2007 or in Word 2003? Microsoft Word Crashed

150 150 rhecht

Recently a co-worker flipped out over the fact that Microsoft Word suddenly crashed on him, taking along an important document that was worked on for 4 hours and for some reason not saved during that time. While a better question would be as to why the document, an important one at that, wasn’t saved throughout that entire period, desperate times called for desperate measures. As it was, Microsoft Word saved the document as an ASD file; the trick was to get it to open in Word.

After doing a bit of research, I came across the following article whose contents I’ve copied for everyone’s benefit.

ASD files are automatic backups of the original file, so word setup the backup file, you need to find the original file or select the file and when the dialog box comes up for what to do with it, select to choose a program from the list, and select word.

1. Click Start, and then click Search.
2. Click All files and folders in Search Companion on the left side of Microsoft Windows Explorer.
3. In the All or part of the file name: box, type the file name that you want to find.
4. In the Look in box, click My Computer, and then click Search.
5. If the results pane does not contain the file, continue with the following steps to search for all Word documents.
6. In the All or part of the file name: box, type *.doc, and then click Search.
Manually recover AutoRecover files
To search for AutoRecover files, follow these steps: 1. Click Start, and then click Search.
2. Click All files and folders in Search Companion on the left side of Windows Explorer.
3. In the All or part of the file name: box, type *.ASD.
4. In the Look in box, click My Computer.
5. Click Search.

If you find any files that have the .asd extension, follow these steps: a. Start Word.
b. Perform one of the following actions:

i.  In Word 2007, click the Microsoft OfficeButton, and then click Open.
ii. In Word 2003, click Open on the File menu.

c. In the File of type list, click All Files .

d. Locate and select the .asd file.

e. Right-click “Open With” and locate from¬†programs where Microsoft Word is.

f. Open with Microsoft Word.

 

If Word finds the AutoRecover file, the Document Recovery task pane opens on the left side of the screen, and the missing document is listed as document name [Original] or as document name [Recovered]. If this occurs, perform one of the following actions:

i. In Word 2007, double-click the file in the Document Recovery task pane, click the Microsoft Office Button, click Save As, and then save the document as a .docx file.
ii. In Word 2003, double-click the file in the Document Recovery task pane, click Save As on the File menu, and then save the document as a .doc file.

Source(s):

Microsoft Outlook IMAP Desktop Alerts Popup – How to Create Rule

150 150 rhecht

I’ve recently been recommending to my clients to switch to IMAP-based email from POP. The technology is newer, everything occurs real-time, and it’s just a better service. However, there are some things that take getting used to, such as purging emails from Outlook and the apparent lack of desktop notification alerts. This post, taken from Microsoft’s site, will address how to allow desktop alerts in Outlook a la POP email setup. -Rafi

 

A Desktop Alert is a notification that appears on your desktop when you receive a new e-mail message, meeting request, or task request. Desktop Alerts are turned on by default. This article explains how you can customize the appearance of Desktop Alerts as well as turn them off.
ZA001077624

Information that Desktop Alerts display

The information displayed in a Desktop Alert varies depending on the item that you receive in your Inbox.

  • E-mail message¬†¬†¬†¬†The alert displays the name of the sender, the subject, and the first two lines of the message. A Desktop Alert does not display the contents of an encrypted or digitally signed message. To view the message, you must open it.
  • Meeting request¬†¬†¬†¬†The alert displays the sender, subject, date, time, and location of the meeting.
  • Task request¬†¬†¬†¬†The alert displays the sender, subject, and start date of the assigned task.

If several items arrive in your¬†Inbox¬†at the same time, you won’t necessarily receive a Desktop Alert for each item. If you receive a large number of items within a particular period of time, Microsoft Outlook displays a single Desktop Alert to indicate that you received several new items. This prevents your desktop from being crowded with alerts that could potentially interfere with your work and temporarily obscure a portion of your desktop.

You can use Desktop Alerts to process your incoming items without opening your¬†Inbox. When a Desktop Alert appears, you can perform several actions that normally require you to open the item. For example, you can set a flag on a message, delete a message, or mark it as read¬†‚ÄĒ all without opening your¬†Inbox.

If you are using a Microsoft Exchange account or a POP3 e-mail account, a Desktop Alert is displayed only when a new item arrives in your default Inbox. If you want to display a Desktop Alert when an item arrives in any other folder, or when you receive items that meet specific conditions, you must create a rule. You must also create a rule if you want to be notified when you receive a new item in an IMAP e-mail account.

TIP:   If you want to keep a Desktop Alert visible so that you can take more time to read it, place your pointer on the alert before it fades from view.

Turn Desktop Alerts on or off

Desktop Alerts are turned on by default. There might be times when you want to turn Desktop Alerts off and then on again. For example, if you are making a presentation to a public audience, you might not want Desktop Alerts to appear on your screen, revealing information that you prefer to keep private. Although Microsoft Outlook will not display Desktop Alerts when you are running a Microsoft Office PowerPoint presentation, the display of alerts will resume if you switch to another program or a Web site during your presentation.

Turn off alerts

  1. On the Tools menu, click Options.
  2. On the Preferences tab, click E-mail Options, and then click Advanced E-mail Options.
  3. Under When new items arrive in my Inbox, clear the Display a New Mail Desktop Alert (default Inbox only) check box.

NOTE   To suppress other notifications such as playing sounds, changing the mouse pointer, or displaying an envelope icon in the notification area, clear the Play a sound, Briefly change the mouse cursor, or Show an envelope icon in the notification area check box, respectively.

Turn off alerts from a Desktop Alert

  1. When a Desktop Alert appears, click the down arrow on the alert.
  2. On the Desktop Alert menu, click Disable New Mail Desktop Alert

ZA010099155

1. Click to open the Desktop Alert menu.
2. Click to turn off Desktop Alerts.

Notice also that you can do other things from the Desktop Alerts menu, such as open, flag, or delete the new message, mark the message as read, or open the Desktop Alert Settings dialog box, where you can specify how long the Desktop Alert should remain visible on the screen and how transparent it should be. See the next section for details.

Turn on alerts

  1. On the Tools menu, click Options.
  2. On the Preferences tab, click E-mail Options, and then click Advanced E-mail Options.
  3. Under When new items arrive in my Inbox, select the Display a New Mail Desktop Alert (default Inbox only) check box.

Change the appearance of Desktop Alerts

You can customize the appearance of your Desktop Alerts. You can have them remain visible as briefly as 3 seconds or as long as 30 seconds. You can also adjust their transparency to make them more noticeable or to keep them from blocking your view of documents and other items on your desktop. Finally, you can change where your Desktop Alerts appear by dragging one of them to a more preferable location on your desktop.

  1. On the Tools menu, click Options.
  2. On the Preferences tab, click E-mail Options, and then click Advanced E-mail Options.
  3. Click Desktop Alert Settings.
  4. Under Duration, drag the slider bar to the number of seconds for which you want new Desktop Alerts to remain visible on your desktop.

NOTE    Although Desktop Alerts eventually fade, the new e-mail notification icon remains in the Outlook status bar until you open the new item or items in your default Inbox.

  1. Under Transparency, drag the slider bar to the transparency value that you want.
  2. To check your settings, click Preview.

NOTE   These settings also apply to the Desktop Alert that can be specified as a rule action.

Move the Desktop Alert to a different location on your screen

  1. On the Tools menu, click Options.
  2. On the Preferences tab, click E-mail Options, and then click Advanced E-mail Options.
  3. Click Desktop Alert Settings.
  4. In the Desktop Alert Settings dialog box, click Preview.

A sample Desktop Alert is displayed on your desktop.

  1. Drag the Desktop Alert to the location that you want.

TIP   You can move the Desktop Alert to a different monitor if your desktop spans more than one monitor.

 

Note: this doc is optimal for Word 2007.

Original Source: http://office.microsoft.com/en-ca/outlook-help/turn-desktop-alerts-on-or-off-HA010098670.aspx

Math/Excel – How to Calculate Percentage Change

150 150 rhecht

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 find the percentage of increase?

Percentage change is calculated this way:

percentchange_1.1

The sign indicates whether it is a decrease or increase. For your example,

percentchange_1.2

  • Since this is a positive figure, it is an 11.5% increase.

    Hope this helps!

    Source: http://mathcentral.uregina.ca/QQ/database/QQ.09.06/s/galland1.html

 

The Evolution of the Modern Computer

150 150 orit

The evolution of the modern computer is a fascinating tale, and one that spans several centuries. The term computer used to refer to a person who worked out calculations or computations. This term was coined in 1613 and did not change its meaning from ‚Äúguy who knows math really well‚ÄĚ to ‚Äúthat mechanical marvel that carries out computations‚ÄĚ until the middle of the 20th century.

History of the Computer

The computer started out as an automated machine that calculated figures and, though it is difficult to find a specific date as to the first time the human mind didn’t have to struggle through complicated figures all on its own, there are quite a few machines that are worthy of honorable mention, such as the Sumerian abacus and the Antikythera mechanism which was used to compute astronomical positions.

In 1642, smack dab in the middle of the Renaissance, the first mechanical calculator, which could perform all four basic mathematical functions without the help of human intelligence, this was the seed from which computers sprouted.

In their infancy, around 1800, computers performed simple tasks, like keeping track of employees’ workday. And in 1837, Charles Babbage designed the first fully programmable computer, however it was his son Henry Babbage that completed and built the first actual computer, this happened in 1888.

In the mid to late 1880’s Herman Hollerith ran with this idea and built the first machine-readable medium for recorded data.

Computers in the 1900’s

Jumping forward a few hundred years, to the first half of the 20th Century, many scientific computing needs were met by increasingly sophisticated versions of the analog computer. And in 1936 Alan Turing provided the blueprint for the modern computer with his Turing machine, which made use of an algorithm to compute more complicated data.

During the 1950’s computers used vacuum tubes as their electronic elements, but these were quickly replaced by semiconductor transistor-based machines, which were cheaper to produce, smaller, which made it easier to create the personal computer, required less power, and were much more reliable. In 1953 the first transistorized computer was demonstrated at the University of Manchester.

In the 1970’s the integrated circuit was invented which paved the way for the microprocessor. This further decreased the cost, size, and malfunctions with computers.

Today’s computers

In the 1980’s computers entered the home and it the personal computer was born. Later, with the invention of the Internet, computers became a form of communication with the outside world, growing to replace and rival the telephone and the television.

The defining characteristic of the modern computer is its programmability. This sets it apart from other household appliances and increases it functionality in the home and workplace as a tool or as a vehicle for your entertainment. There are many great companies out there to get a good computer for your family, look at dell.ca for great deals.

What is the SRS file in Microsoft Outlook? (And where is it?)

150 150 rhecht

I frequently tell people to ‚Äúdelete the SRS‚ÄĚ to fix problems with send and receives, especially when Outlook crashes when they try to view the Send and Receive menu or do a send and receive.

If you haven’t guessed yet, SRS is the send and receive settings file. It holds the configurations found in the Send and Receive dialog that comes up when you press Ctrl+Alt+S. I have no idea what causes it to become corrupt, but deleting (or renaming it) fixes the problem. Outlook will create a new one containing the default settings when you restart it.

Delete or Rename the file? In most cases, the user does not have a lot of customizations configured in the Send and Receive dialog so deleting the file is fine, even if it turns out it wasn’t the problem. If you made a lot of customizations to your send and receive settings, you can rename it until you find out if it was the problem. If the problem continues after restarting Outlook, it wasn’t the SRS file.

The SRS is in the ‚Äúroaming‚ÄĚ Outlook folder under your Windows user account.

In Vista and Windows7, the SRS is at

C:UsersusernameAppDataRoamingMicrosoftOutlook
In Windows XP and 2000, its at

C:Documents and SettingsusernameApplication DataMicrosoftOutlook
It‚Äôs easy to open the folder where the SRS file is by entering a simple command in the Windows Explorer address bar. (No need to type it ‚Äď click 3 times in the box to select the command then copy and paste.)

In Vista or Windows 7, use

%appdata%microsoftoutlook

In Windows XP or Windows 2000, use
%USERPROFILE%Application DataMicrosoftOutlook

This folder is a ‚Äúhidden file or folder‚ÄĚ, so you‚Äôll need to enable Show hidden files and folders in Windows Explorer options if you want to browse to the folder, or search for hidden files and folder if you use search.

Post originally found on OutlookTips.net.

Excel: How to Replace Text in a Cell

150 150 rhecht

How to Replace Text in a Cell in Excel?

Use the Substitute(text, old_text, new_text, [instance_num]) function.

This has saved me a lot of time when formatting raw data.

How to Set Up Domain Mapping for WordPress Multisite

150 150 rhecht

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 of using subdomains of your main installation. Well, with a little extra effort, it’s entirely possible.

Install the required plugin

There’s an excellent plugin that will do most of the hard work for you. Install the WordPress MU Domain Mapping plugin and Network Activate the plugin.

Before you proceed any further, there’s a couple of things that you have to do manually. Access your site’s installation, either using FTP or your hosting Control Panel and go to wp-content/plugins/wordpress-mu-domain-mapping/ and locate the sunrise.php file. You must move this file up two levels, to the wp-content folder.

Once you‚Äôve done that,¬†find your wp-config.php file and add the following definition. Add it below your previous multisite rules (i.e. above the ‚ÄúStop editing‚ÄĚ line):

define( 'SUNRISE', 'on' );

Domain-Mapping.php
Move “domain-mapping.php” to the mu-plugins” folder at the wp-content “root” level. This is important as certain web servers won’t render the mapped URLs correctly unless this is done.

Configure the plugin

Now your plugin is correctly installed and when you head to the Network Admin area you’ll notice a menu under Settings called Domain Mapping. Click on that so that you can configure the plugin.
The main thing you need to be concerned with is setting the IP address of your server. To find this, log in to your hosting cPanel and on the main page, you should be able to see the IP address of your server in the information on the left-hand side. If you can’t find the IP address, you can get in touch with your host, or use one of many available free tools to convert the web address to an IP address.

If you fill out the IP address, you can ignore the CNAME field. Then, the remaining options are as follows:

  1. Remote Login ‚Äď Means that logging in to one site will log you in to all sites.
  2. Permanent Redirect ‚Äď This will create a 301 redirect on your subdomain (as opposed to a temporary 302 redirect) ‚Äď highly recommended if the domain mapping will be permanent.
  3. User Domain Mapping Page ‚Äď Creates a new menu in each site which allows that site‚Äôs users to map their own domains (instead of being controlled by the network‚Äôs Super Admin only).
  4. Redirect administration pages ‚Äď Means that all administration pages will be kept on the original site‚Äôs domain, instead of on the mapped domains.
  5. Disable primary domain check ‚Äď Means that multiple domains pointing to a single site will be treated as separate sites, instead of redirecting all domains to the noted primary domain (not recommended).

Map domains to your network sites

Now you‚Äôre ready to set up the domain for your new sites. You should have already created the site that you‚Äôre wanting to map your domain to. At the moment, it will just be a subdomain of your main site ‚Äď it doesn‚Äôt have to be set up or looking perfect ‚Äď it just has to exist.

Once you’ve purchased your domain, make sure that you set the nameservers for the domain to your hosting account’s nameservers. Then, go to your hosting account cPanel (which all good hosts, including HostGator, should have) and find the Parked Domains option under Domains.

Once in there, add your new domain as a parked domain, making sure that the document root shows as the same folder as your WordPress installation (probably /public_html). If you can’t do this (because you don’t have cPanel for instance), you need to set an A record on your new domain that points to the IP address of your hosting server (which you found out earlier).

Now is the final step. You‚Äôll¬†need to know the ‚ÄúSite ID‚Ä̬†of the site you want to map the domain to. If you click on Sites > Sites in the Network Admin, and click on the name of the site (as if to edit it), the URL will include the site ID. It will look something like this (where the Site ID is 2 in the example):

http://wpsites.rafihecht.com/wp-admin/network/site-info.php?id=2

Now back in your Network Admin, go to Domains under the Settings Menu. You’ll see a section for adding a new domain, with three fields: one for the site ID, which you just found out, the domain name and an option whether to set the domain as the primary domain for the site. This is because you can set more than one domain to point to a single site, so you want to specify which one should be the site’s primary domain.

Once you save that, with any luck (and assuming that DNS changes have propagated), if you go to your new domain in a web browser, you should find yourself at your new site.

I’ll grant you that it is a little bit fiddly, and it would be nice if WordPress would bring this into the core and make it a bit more of a fluid process, but once it is set up, you never need to look at it again; the plugin will keep serving up the right site at the right domain.

Did you manage to get through the setup process? Did you encounter any problems? If you need any help getting through this process, you can always ask a question here, or hire me to do it for you.

 

Content of this part of the blog post was courtesy of : http://www.doitwithwp.com/domain-mapping-for-wordpress-multisite/