Excel Replace Asterix and Tilde

Example 1: How to find and to replace numbers
To replace wildcard characters (*) in a numeric value in a worksheet cell, follow these steps:
  1. Type 494** in cell A1.
  2. Select cell A1.
  3. On the Edit menu, click Replace.
    Note In Microsoft Office Excel 2007, click Find & Select in the Editing group on the Home tab, and then click Replace.
  4. In the Find what box, type ~*. To do this, press TILDE, and then press ASTERISK.
  5. In the Replace with box, type 2.
  6. Click Replace.
Cell A1 now reads 49422.
Notes
  • When you click Replace All, Excel makes the change throughout the worksheet. When you click Replace, Excel changes only the currently active cell and leave the Replace dialog box open.
  • When you type an asterisk without a tilde in the Find what box, Excel replaces all entries with a 2. Excel treats the asterisk as a wildcard character. Therefore, 494** becomes 2.

Example 2: How to find and to replace a tilde

To replace a tilde in an Excel worksheet cell, follow these steps:
  1. Type Micros~1.xls in cell A1.
  2. Select cell A1.
  3. On the Edit menu, click Replace.
    Note In Excel 2007, click Find & Select in the Editing group on the Home tab, and then click Replace.
  4. In the Find what box, type ~~.
  5. In the Replace with box, type oft.
  6. Click Replace All.
Cell A1 now reads Microsoft1.xls.

Outlook 2010 Internet Message Headers

Message Headers are a key way to look at the technical information about email that is sent to you. It helps IT people determine the back ground on the message such as its origin and the route it took to get to your mail server.

Since the 2007 version of outlook, it has become increasingly more hidden. Here is how to find it.

To see the Internet headers for an email message

  1. Open the message in its own window (not the reading pane) in Outlook 2010.

  2. Click File, and then click Properties.

  3. Look for the section Internet headers at the bottom of the Properties dialog box.

Outlook uses some header information, such as the information in the From, To, and Sent fields in an Outlook message. For more information about common Internet headers, see View e-mail message headers.

Jeff Loucks
Chief Strategy Officer | Winrox | 425-577-7377

Office 365 – How to Change Primary Email Address For a User

Scenario: Your company uses a sign in domain however some users need to be able to send from a different email as their primary email address.

Example:

  • You sign in with  image
  • Your outgoing email address image

The Office 365 graphical user interface does not currently give you the ability to change this setting.

So you need to be able to get dirty with PowerShell and here are the steps.

Prerequisites:

Download and install Microsoft Online Services Module for Windows PowerShell

Stage 1 – Setting Up PowerShell to receive the commands

  1. Run the PowerShell module as administrator.
  2. Type:
    Set-ExecutionPolicy -ExecutionPolicy unrestricted
    and press Enter
  3. Type:
    $LiveCred = Get-Credential
    and press Enter
  4. You will be prompted to log in. Use your Office365 administrative account.
  5. Type:
    $Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://ps.outlook.com/powershell/ -Credential $LiveCred -Authentication Basic –AllowRedirection
    and press Enter.
  6. Type:
    Import-PSSession $Session
    and press Enter.

Stage 2 – Getting the email addresses and changing the primary

  1. Type:
    $Mailbox = Get-Mailbox –Identity Jeff
    and press Enter. Where Jeff is the part of the login email address in front of the @ sign (ie. image)

  2. Type:
    ForEach ($i in $Mailbox.EmailAddresses) {Write-Host $i -NoNewline "`b, "}
    and press enter.

    Note:
    You now have all of the information required to change the primary email address. You need to use the output of the previous command to build you next command. We will start by adding something to the front of the output and then remove a comma from the end. Finally we will change capitalization of SMTP within the output to specify which email address is the primary.
    I suggest you copy the output to notepad, make the edits and then copy the final command back.

  3. Add to the front of the output from line 2 type:
    Set-Mailbox Jeff –EmailAddresses

    Note: Jeff is the login name before the @ sign in the email address. This will change based on your account information. Ensure there is a space between the text you just added and the start of the output from step 2.

  4. Now go to the end of the output from step 2 and remove the trailing comma.

  5. Now find the email address you want to make the primary email address within the output from step 2 and capitalize SMTP just before it. You will also need to change the old primary SMTP to miniscule letters smtp.

  6. The command in notepad should look like this:
    image

  7. Copy the command back into PowerShell and press Enter.

    Note: if you need to change more than one email address just repeat the steps in Stage 2.

  8. Once you have finished modifying the primary email addresses you shall issue the following command:
    Remove-PSSession $Session
    and press Enter

Stage 3 – Testing the email addresses

Ensure the users test the email addresses by sending them to a non-office365 email address that you can verify such as Hotmail.

Jeff Loucks
Chief Strategy Officer | Winrox | 425-577-7377

Office 365– Send email from Alias

Ok you have got multiple email addresses and you want to be able to send from the same Office 365 account. If you have been administering Exchange for any time you know the work around is to use a POP3 account. The question is how do you get the workaround to work with Office 365?


For those of you reading and asking the question how do I receive email from multiple addresses, please note that this post does not cover this topic. More Info on Receiving Email from Alias.


Prerequisites:


  • You need a computer with Outlook Installed.
  • You need to be able to sign in to Office 365 with at least one of the users accounts.
  • You need to have previously set up the ability to have other email addresses/aliases as linked to above.

Steps to complete task:


1) Sign into to https://portal.microsoftonline.com/ and select Outlook
PortalMenu
2) Click the Options link then select See All Options
OutlookOptions
3) On the My Account tab and click the link for Settings for POP, IMAP, and SMTP access…
SettingsPOP3
4) Copy the server server names for POP and SMTP. They will probably be the same, but make sure.
image
5) On the computer with outlook installed, click File > Account Settings > then Account Settings again.
image
6) On the email tab click new
image
7) On the Add New Account window, click Manually configure… and then click next.
image
8) Select Internet Email
image
9) Fill in the information and then click More Settings
image
10) On the Internet E-mail Settings window in the Outgoing Server tab, click to enable My Outgoing Server (SMTP) requires authentication.
image
11) Select the Advanced tab. Check require (SSL). Change Outgoing Server (SMTP) to 587. Select TLS from the Use the following type of encryption dropdown. Click OK to close the dialogue.
image
12) Click Next, test the account settings, and then click through to Finish
13) Click File> Options> Advanced
14) Scroll down to Send and receive and click the Send/Receive button
15) In the Group Name area, select All Accounts, and then click Edit
16) Deselect the ‘Include the selected account in this group.’
17) Click OK > click Close > click OK
18) Test it by creating a new email message
19) Click the Options tab > find the Show Fields group > click to show the ‘From: field.’
image

Jeff Loucks
Chief Strategy Officer | Winrox | 425-577-7377