Excel Formula Training Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You tell Excel the value to find, such as “ABC Company” and you tell Excel where to look, such as in a range of cells. You are asking Excel to find the lookup value in the lookup range. Step two, the return, is the function’s result.

  1. Excel For Mac 2018 If Then Find String In Stored
  2. Excel For Mac 2018 If Then Find String Length

This article describes the formula syntax and usage of the LEN and LENB functions in Microsoft Excel.

Description

LEN returns the number of characters in a text string.

LENB returns the number of bytes used to represent the characters in a text string.

Important:

  • These functions may not be available in all languages.

  • LENB counts 2 bytes per character only when a DBCS language is set as the default language. Otherwise LENB behaves the same as LEN, counting 1 byte per character.

The languages that support DBCS include Japanese, Chinese (Simplified), Chinese (Traditional), and Korean.

Syntax

LEN(text)

LENB(text)

The xxx function syntax has the following arguments:

  • Text Required. The text whose length you want to find. Spaces count as characters.

Example

Example 1: LEN

Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter. If you need to, you can adjust the column widths to see all the data.

Data

Phoenix, AZ

One

Formula

Description

Result

=LEN(A2)

Length of the first string

11

=LEN(A3)

Length of the second string

0

=LEN(A4)

Length of the third string, which includes 5 spaces

11

Example 2: LENB (with your computer set to a default language that supports DBCS)

Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter. If you need to, you can adjust the column widths to see all the data.

Data

Phoenix, AZ

One

Formula

Description

Result

=LEN(A2)

Length of the first string

11

=LEN(A3)

Length of the second string

0

=LEN(A4)

Length of the third string, which includes 5 spaces

11

-->

Office for Mac that comes with an Office 365 subscription is updated on a regular basis to provide new features, security updates, and non-security updates.

Updates are available from Microsoft AutoUpdate (MAU). To use Microsoft AutoUpdate, start an Office application, such as Word, and then choose Help > Check for Updates. If you're an admin and want to update the computers in your organization with your existing software deployment tools, you can download and deploy the update packages for each application.

Note

  • For a list of all Office for Mac releases, Update packages and additional download links, see Update history for Office for Mac.
  • If you're an Office Insider, see Release notes for Insider Fast builds.
  • Starting with the 16.17 release in September 2018, these release notes also apply to Office 2019 for Mac, which is a version of Office for Mac that’s available as a one-time purchase from a retail store or through a volume licensing agreement. But, some features listed in the release notes are only available if you have an Office 365 subscription.
  • The release notes for version 16.16 and earlier also apply to Office 2016 for Mac, which is also a version of Office for Mac that’s available as a one-time purchase. Older versions up to and including 16.16 can be activated with an Office 2016 for Mac volume license. You can’t activate version 16.17 or later with an Office 2016 for Mac volume license. For information about Office 2016 for Mac releases from September onward, see Release notes for Office 2016 for Mac.
  • We often roll out features (and sometimes even fixes) to Monthly channel over a period of time. This allows us to ensure that things are working smoothly before releasing the feature to a wider audience. So, if you don’t see something described below, don't worry you'll get it eventually. Learn more

Note: Microsoft AutoUpdate (MAU) release information has moved to the MAU Release History page.

August 13, 2019 release

Version 16.28 (Build 19081202)

Word: Feature updates

  • Sketch It Out: Give a casual, hand-drawn look to Office shapes in your presentation. Learn more
  • Erase with Precision: Choose from two eraser sizes to fix small inking imperfections. Learn more
  • Improved map charts: We've made map charts better by integrating them with Excel's Geographic Data Types, which can reveal rich information about your mapped locations. Learn more

Word: Security updates

  • CVE-2019-1201: Microsoft Word Remote Code Execution Vulnerability
  • CVE-2019-1205: Microsoft Word Remote Code Execution Vulnerability

Excel: Feature updates

  • Sketch It Out: Give a casual, hand-drawn look to Office shapes in your presentation. Learn more
  • Focus on What's Left to Do: Select Resolve to collapse comments and make open items stand out.
  • Improved map charts: We've made map charts better by integrating them with Excel's Geographic Data Types, which can reveal rich information about your mapped locations. Learn more

PowerPoint: Feature updates

  • Sketch It Out: Give a casual, hand-drawn look to Office shapes in your presentation. Learn more
  • Persistent Inking During Slide Show: Draw on your slides during a presentation and your pen stays active until the end. Save the annotations, too. Learn more
  • Improved map charts: We've made map charts better by integrating them with Excel's Geographic Data Types, which can reveal rich information about your mapped locations. Learn more

Outlook: Feature updates

  • Share Attachments From Your Cloud Files: Easily attach cloud files to your email messages for enhanced collaboration. Learn more

Office Suite: Feature updates

  • Privacy controls: New, updated, and improved controls for diagnostic data and connected experiences. Learn more

Office Suite: Security updates

  • CVE-2019-1148: Microsoft Graphics Component Information Disclosure Vulnerability
  • CVE-2019-1149: Microsoft Graphics Remote Code Execution Vulnerability
  • CVE-2019-1151: Microsoft Graphics Remote Code Execution Vulnerability
  • CVE-2019-1153: Microsoft Graphics Component Information Disclosure Vulnerability

July 16, 2019 release

Version 16.27 (Build 19071500)

Word: Feature updates

  • Fixed various performance issues.

Excel: Feature updates

  • Fixed various performance issues.

Excel: Security updates

  • CVE-2019-1110: Microsoft Excel Remote Code Execution Vulnerability
  • CVE-2019-1111: Microsoft Excel Remote Code Execution Vulnerability

PowerPoint: Feature updates

  • Fixed various performance issues.

Outlook: Feature updates

  • Share Attachments From Your Cloud Files: Easily attach cloud files to your email messages for enhanced collaboration.
  • Dark Mode support in Reading Pane: Emails you receive now have a dark background for easier viewing in low-light environments. Requires macOS Mojave.

Outlook: Security updates

  • CVE-2019-1084: Microsoft Exchange Information Disclosure Vulnerability

June 11, 2019 release

Version 16.26 (Build 19060901)

Word: Feature updates

  • Get Their Attention with @Mentions: Use @mentions in comments to let others know when you need their input.

Word: Security updates

  • CVE-2019-1034: Microsoft Word Remote Code Execution Vulnerability
  • CVE-2019-1035: Microsoft Word Remote Code Execution Vulnerability

Excel: Feature updates

Excel For Mac 2018 If Then Find String In Stored

  • Get Their Attention with @Mentions: Use @mentions in comments to let others know when you need their input.
  • To Group or Not to Group: PivotTable dates don't have to be grouped. Turn off automatic grouping at: Excel > Preferences > Tables & Filters.
  • Subscript and Superscript at a Glance: If subscript, superscript, and strikethrough are your go-to formats, add them to your ribbon and Quick Access Toolbar so they're within easy reach.

PowerPoint: Feature updates

  • Get Their Attention with @Mentions: Use @mentions in comments to let others know when you need their input.
  • Online Videos Have a New Home: Save a video to Microsoft Stream so that anyone in your organization can see it. Insert the video link and enjoy a multimedia presentation at a fraction of the file size.
  • Live Captions and Subtitles: Your words are automatically shown as captions or translated into another language as subtitles while you present. For best results, use a headset microphone.

Outlook: Feature updates

  • From Outlook to OneNote in Just One Click: With the click of a button you can save your Outlook messages and meeting notes to a OneNote notebook. Use it as an archive or as a convenient place to stash your stuff.

May 2019 release

Release Date: May 14, 2019

Version 16.25 (Build 19051201)

Then

This release provides the following updates:

ApplicationUpdateSecurity updatesDownload link for update package
Word
See your email attachments: Your email attachments are now available in the Shared tab.CVE-2019-0953: Microsoft Word Remote Code Execution Vulnerability
Word update package
Excel
See your email attachments: Your email attachments are now available in the Shared tab.
Coauthoring merge improvements: Coauthoring has improved the merge success rate when working with conditional formatting, cell styles, range protection, view gridlines, and cross-sheet cut/paste.

Excel update package
Powerpoint
See your email attachments: Your email attachments are now available in the Shared tab.
Work Faster with New Shortcuts: We've got keyboard shortcuts for things like crop, send forward/send backward, and list-item promotion/demotion.

PowerPoint update package
Outlook
Know your contacts’ availability at a glance: See presence information for your contacts that are on Teams right within Outlook.
See Key Details for Your Contacts: Select a contact's name in a message or calendar event to see their photo, phone number, email, org chart, and more. Learn More
Outlook update package

April 2019 release

Release Date: April 29, 2019

Version 16.24.1 (Build 19042400)

This release provides the following updates:

ApplicationFeature updatesSecurity updatesDownload link for update package
Word
Updates bundled fonts to include new Japanese Era glyph.

Word update package
Excel
Updates bundled fonts to include new Japanese Era glyph.

Excel update package
Powerpoint
Updates bundled fonts to include new Japanese Era glyph.

PowerPoint update package
Outlook
Updates bundled fonts to include new Japanese Era glyph.

Outlook update package
OneNote
Updates bundled fonts to include new Japanese Era glyph.

OneNote update package

Release Date: April 16, 2019

Version 16.24 (Build 19041401)

This release provides the following updates:

ApplicationFeature updatesSecurity updatesDownload link for update package
Word
New Office App Icons: Redesigned app icons to reflect the simple, powerful, and intelligent experiences of Office.
Get a Faster Start: Get recommendations based on your activity and what others are working on around you.
Watch Your Documents Come Alive: Insert animated 3D graphics to see hearts beat, planets orbit, and T-Rex rampage across the page. Learn More

Word update package
Excel
New Office App Icons: Redesigned app icons to reflect the simple, powerful, and intelligent experiences of Office.
Calling All Macro Users: Record a macro using relative references. When you play it back, it works in relation the active cell, not the cells used for recording. Learn More
Your Favorite Commands Within Easy Reach: Get quick, easy access to common actions like Find & Select, Zoom to Selection, Arrange All, and more. Find them on the ribbon. Learn More
Get a Faster Start: Get recommendations based on your activity and what others are working on around you.
Watch Your Worksheet Come Alive: Insert animated 3D graphics to see hearts beat, planets orbit, and T-Rex rampage through the workbook. Learn More
CVE-2019-0828: Microsoft Excel Remote Code Execution VulnerabilityExcel update package
Powerpoint
New Office App Icons: Redesigned app icons to reflect the simple, powerful, and intelligent experiences of Office.
Get a Faster Start: Get recommendations based on your activity and what others are working on around you.
Easily Save Embedded Media: Save audio and videos with just a Control + click. Learn More
Watch your Slides Come Alive: Insert animated 3D graphics to see hearts beat, planets orbit, and T-Rex rampage across the screen. Learn More
PowerPoint update package
Outlook
New Office App Icons: Redesigned app icons to reflect the simple, powerful, and intelligent experiences of Office.
Safe Links: Support for Advanced Threat Protection (ATP) Safe Links.
Outlook update package
Microsoft Auto Update 4.10
Install On Clone Feature Enhancements: For SSD devices, rolling out updates on clone for apps in use, thereby reducing the app downtime due to updates.
Installation Optimizations: The update process will use parallelized cloning, so app downtime due to updates will be reduced.

Microsoft AutoUpdate update package
Office Suite
CVE-2019-0822: Microsoft Graphics Components Remote Code Execution Vulnerability

March 2019 release

Release Date: March 27, 2019

This release provides the following updates:

ApplicationUpdateSecurity updatesDownload link for update package
Outlook
Fixes an issue with removal of shared or delegated calendars. Learn more
Outlook update package

Release Date: March 14, 2019

This release provides the following updates:

ApplicationFeature updatesSecurity updatesDownload link for update package
Microsoft Auto Update 4.9
Bug fixes and update installation performance improvements.

Microsoft AutoUpdate update package

Release Date: March 12, 2019

This release provides the following updates:

ApplicationFeature updatesSecurity updatesDownload link for update package
Word
**Get Their Attention with @Mentions:** Use @mentions in comments to let co-workers know when you need their input. Learn More
LaTex Equation Editing: Word now supports LaTeX math syntax to create math equations. Learn More
Word update package
Excel
**Get Their Attention With @Mentions:** Use @mentions in comments to let co-workers know when you need their input. Learn More
Discover More About Your Data: The new Ideas button looks for patterns in your data, and uses them to create intelligent, personalized, suggestions. Learn More

Excel update package
Powerpoint
Better Shapeshifting: Move your finger on the trackpad and watch ink flow across the screen. Learn More

PowerPoint update package
Outlook

Outlook update package

February 2019 release

Release Date: February 26, 2019

This release provides the following updates:

ApplicationFeature updatesSecurity updatesDownload link for update package
Microsoft Auto Update 4.8
Fixed an issue with MAU Opt Into Automatic Updates’ Prompt for MacOS 10.10
Updated to MAU ApplicationID from 'MSau03' to 'MSau04'
Fixed an issue with MAU Privileged Helper for installation while another version is running

Microsoft AutoUpdate update package

Release Date: February 20, 2019

Version 16.22.1 (Build 19022000)

This release provides the following updates:

ApplicationFeature updatesSecurity updatesDownload link for update package
Outlook
Fixed an issue with authentication for Google Accounts.
Fixed an issue with calendar synchronization.
Outlook update package

Release Date: February 12, 2019

Version 16.22.0 (Build 19021100)

This release provides the following updates:

ApplicationFeature updatesSecurity updatesDownload link for update package
Word
Sketch with Your Trackpad: Move your finger on the trackpad and watch ink flow across the screen. Learn More
Make Your Images Accessible: When you insert a picture, Office suggests captions that can be read by people with vision impairments.
Word update package
Excel
Sketch with Your Trackpad: Move your finger on the trackpad and watch ink flow across the screen. Learn More
CVE-2019-0669
Excel update package
Powerpoint
Sketch with Your Trackpad: Move your finger on the trackpad and watch ink flow across the screen. Learn More
Hyperlinks in Living Color: Hyperlinks aren't just blue anymore. Apply any font color you like. Learn More

PowerPoint update package
Outlook

Outlook update package
Microsoft Auto Update 4.7


Microsoft AutoUpdate update package
Office Suite
Quickly change selected picture from the ribbon from different sources: Change Picture will allow users to change their selected picture/graphic to a picture from our Online Picture feature, Icons library, or the clipboard.

January 2019 release

Release Date: January 24, 2019

Version 16.21.0 (Build 19011700)

This release provides the following updates:

ApplicationFeature updatesSecurity updatesDownload link for update package
Word
Fixed an issue with Chinese localization.
Break the Language Barrier: Translate words, phrases, or the whole document to another language with Microsoft Translator. Do this from the Review tab on the ribbon.
Word update package
Outlook
Fixed an issue with Chinese localization.
Optimize sync based on power and network status: Outlook now optimizes sync for your Exchange accounts when on battery and limited network, such as airplane wi-fi.
All the Meeting Details At a Glance: Click the event in your calendar to see all the meeting details. Check out who was invited, edit your response, or join the meeting, all in one place. Learn More
Outlook update package

Release Date: January 23, 2019

Version 16.21.0 (Build 190102303)This release provides the following updates:

ApplicationFeature updatesSecurity updatesDownload link for update package
Excel
Fixed a regression in character spacing when mixing unicode and non-unicode.

Excel update package

Release Date: January 16, 2019

Version 16.21.0 (Build 190101500)

This release provides the following updates:

ApplicationFeature updatesSecurity updatesDownload link for update package
Word
From iPhone to Word in a Snap: Use the Apple Continuity Camera to insert a photo from your iPhone into your document. Requires macOS Mojave. Learn More
Apply sensitivity labels to your documents: Apply sensitivity labels to your documents to keep them compliant with your organization's information protection policies. Learn More
Ability to insert SVG's with filters applied: Office users now have the ability to insert SVG's that have filters applied to them. Learn more
CVE-2019-0561: Microsoft Word Information Disclosure Vulnerability
CVE-2019-0585: Microsoft Word Remote Code Execution Vulnerability
Word update package
Excel
Collaborate with Comments: Keep the conversation going right in your spreadsheet with the built-in reply box. Learn More
Apply sensitivity labels to your worksheets: Apply sensitivity labels to your worksheets to keep them compliant with your organization's information protection policies. Learn More
Ability to insert SVG's with filters applied: Office users now have the ability to insert SVG's that have filters applied to them. Learn more
SVG Support: Insert and edit SVG's in your workbooks to add visual impact. Learn More
More formatting options for Histogram, Waterfall, Treemap, Sunburst, Funnel and Map charts: You have more control of the formatting options for the new chart types by using the format pane.
Excel update package
Powerpoint
Print slide numbers in handouts: When you print a presentation into handouts, each slide will show an accompanying slide number.
Apply sensitivity labels to your presentations: Apply sensitivity labels to your presentations to keep them compliant with your organization's information protection policies. Learn More
Ability to insert SVG's with filters applied: Office users now have the ability to insert SVG's that have filters applied to them. Learn more
Embed a subset of the fonts: Embed only the characters used in the presentation. Learn More
PowerPoint update package
Outlook
Apply sensitivity labels to your messages: Apply sensitivity labels to your messages to keep them compliant with your organization's information protection policies. Learn More
Ability to insert SVG's with filters applied: Office users now have the ability to insert SVG's that have filters applied to them. Learn more
Find Mail Fast in Your Current Mailbox: Select the Search box for quick suggestions based on your recent search history. No typing required. Learn More
Adding Gmail Accounts Just Got Easier: Security improvements mean you no longer need to allow access for 'less secure apps' or set an app password in order to add your Gmail account to Outlook.
Outlook for Mac now highlights search terms: Ever tried searching for something and wished Outlook would highlight your search term in the item list and preview pane? Well, wonder no more as it's here!
Outlook update package
Microsoft Auto Update 4.7
The AutoUpdate daemon is now launched as part of the installation process. This eliminates confusing security dialogs that were previously shown to users.
Microsoft AutoUpdate’s security features have been enhanced to support SHA256 certificates.

Microsoft AutoUpdate update package

Note

Starting with Version 16.21, Microsoft Teams will be installed by default for new installations. For more information, see Microsoft Teams installations on a Mac.

December 2018 release

Then

Release Date: December 11, 2018

Version 16.20.0 (Build 18120801)

This release provides the following updates:

ApplicationFeature updatesSecurity updatesDownload link for update package
Word
Go Easy on Your Eyes with Dark Mode: A dark background is easier on the eyes in low-light environments. Requires macOS Mojave.
Preserve the Look of Your Text: Embed fonts to ensure that your document's text looks the same on every computer. No more surprises! Learn More
View embedded fonts in documents: Allows fonts that have been embedded in a file to be rendered in Mac Word.
Focus mode invokable status bar: In Focus mode, more easily see Word count and access zoom controls with invokable status bar.
Get More with Focus Mode: We heard you! Now, Focus Mode opens at your set zoom level and also shows the page number while you scroll.
Word update package
Excel
Go Easy on Your Eyes with Dark Mode: A dark background is easier on the eyes in low-light environments. Requires macOS Mojave.
CVE-2018-8597: Microsoft Excel Remote Code Execution Vulnerability
CVE-2018-8627: Microsoft Excel Information Disclosure Vulnerability
Excel update package
Powerpoint
Go Easy on Your Eyes with Dark Mode: A dark background is easier on the eyes in low-light environments. Requires macOS Mojave.
From iPhone to PowerPoint in a Snap: Use the Apple Continuity Camera to insert a photo from your iPhone into your slide. Requires macOS Mojave. Learn More
CVE-2018-8628: Microsoft PowerPoint Remote Code Execution Vulnerability
PowerPoint update package
Outlook
Go Easy on Your Eyes with Dark Mode: A dark background is easier on the eyes in low-light environments. Requires macOS Mojave.
Share your calendar: Share your calendar with family, friends, and colleagues. Open calendars shared with you in Mac, PC, or cloud versions of Outlook. Learn More
Turn Off Forwarding for a Meeting: Prevent attendees from forwarding your meetings to others. Learn More
Use Teams to Connect to your Meetings: Work with remote teams? Use Teams in Outlook to schedule and join online meetings. Learn More
See who's coming to the meeting: Click any meeting or event in your calendar to see who plans to be there.
View three time zones: Need to schedule a meeting across time zones? Add multiple time zones to your calendar to easily see everyone's availability and pick a time that works for all. Learn More
Outlook update package
Microsoft Auto Update 4.6
Updated security catalogs to contain SHA-256 hashes instead of SHA-1

Microsoft AutoUpdate update package
Office Suite
Your Ribbon Icons Have a New Look: Don't worry, everything works the same. Plus all of the icons look great on screens of all sizes. Learn More
Updated Alt Text Pane: Make your content more accessible by adding helpful captions or even mark elements as decorative.

November 2018 release

Release Date: November 13, 2018

Version 16.19.0 (Build 18110915)

This release provides the following updates:

ApplicationFeature updatesSecurity updatesDownload link for update package
Word
Get the Picture? Search the web for pictures from within your Office apps. Select Insert > Online Pictures to begin.Learn More
What's in a Filename? Handy Tools: Click the filename to quickly move, rename, or browse the version history for your cloud documents. Learn More
Word update package
Excel
Get the Picture? Search the web for pictures from within your Office apps. Select Insert > Online Pictures to begin.Learn More
What's in a Filename? Handy Tools: Click the filename to quickly move, rename, or browse the version history for your cloud documents. Learn More
CVE-2018-8574: Microsoft Excel Remote Code Execution Vulnerability
CVE-2018-8577: Microsoft Excel Remote Code Execution Vulnerability
Excel update package
Powerpoint
Get the Picture? Search the web for pictures from within your Office apps. Select Insert > Online Pictures to begin.Learn More
What's in a Filename? Handy Tools: Click the filename to quickly move, rename, or browse the version history for your cloud documents. Learn More
Zoom - present your content in a non-linear way: Create an interactive table of contents with Summary Zoom, or jump to specific slides and sections with Slide Zoom and Section Zoom. Learn more
Export to Video with audio narrations: Audio narrations are now included in your exported video.
PowerPoint update package
Outlook
Easier Email Encryption: The Encrypt button now has an Encrypt-Only option, which makes it easier to send encrypted email—inside and outside your organization. Learn more
Outlook update package
Office Suite

Microsoft Auto Update 4.5
- Support for Dark Mode
- Bug fixe for daemon crash (Updated to Aria SDK 8.5.2.0)

Microsoft AutoUpdate update package

October 2018 release

Release Date: October 16, 2018

Version 16.18.0 (Build 18101400)

This release provides the following updates:

ApplicationFeature updatesSecurity updatesDownload link for update package
Word
Word update package
Excel
Collaborate with Comments: Keep the conversation going right in your spreadsheet with the built-in reply box. Learn more
More 'auto' in AutoComplete: When you type a formula, the helpful AutoComplete menu will appear, showing you argument options to choose from.
Now improved: VoiceOver navigation: Using VoiceOver in Excel? Move across sheets by pressing VO+U. You can enable the macOS Trackpad Commander to do this too.
Excel update package
Powerpoint
Make Your Images Accessible: When you insert a picture, Office suggests captions that can be read by people with vision impairments.
Animation Triggers are here: You asked for it! Animation triggers aren't just for Windows anymore. Find them on the Animations tab. Learn more
PowerPoint update package
Outlook
Improved Search: Select the Search box for quick suggestions based on your recent search history. No typing required. Learn more
Outlook update package
Office Suite
CVE-2018-8432 Microsoft Graphics Components Remote Code Execution Vulnerability

September 2018 release

Release Date: September 11, 2018

Version 16.17.0 (Build 18090901)

This release provides the following updates:

ApplicationFeature updatesSecurity updatesDownload link for update package
Word

Draw with ink: Use your mouse or touch pad, and the pens on the Draw tab to write, draw, and highlight. Learn more
Insert 3D models to see all the angles: Easily insert a 3D model, and then rotate it through 360 degrees. Learn more
Word update package
Excel
Draw with ink: Use your mouse or touch pad, and the pens on the Draw tab to write, draw, and highlight. Learn more
Insert 3D models to see all the angles: Easily insert a 3D model, and then rotate it through 360 degrees. Learn more
Custom shortcuts are back: We heard you! At your request, we've brought back custom shortcut keys. Learn more
CVE-2018-8429: Microsoft Excel Information Disclosure Vulnerability
CVE-2018-8331: Microsoft Excel Remote Code Execution Vulnerability
Excel update package
PowerPoint

Draw with ink: Use your mouse or touch pad, and the pens on the Draw tab to write, draw, and highlight.Learn more
Insert 3D models to see all the angles: Easily insert a 3D model, and then rotate it through 360 degrees. Learn more
The font you choose is the font they see: Embed your custom fonts in your files so that wherever they go, your fonts go too. Learn more
PowerPoint update package
Outlook
Outlook update package
Microsoft AutoUpdate 4.3
Office suite
CVE-2018-8332: Microsoft Graphics Remote Code Execution Vulnerability

August 2018 release

Release Date: August 14, 2018

Version 16.16.0 (Build 18081201)

This release provides the following updates.

ApplicationFeatures updatesSecurity updatesDownload link for update package
Word
Word update package
Excel
CVE-2018-8375: Microsoft Excel Remote Code Execution Vulnerability
CVE-2018-8382: Microsoft Excel Information Disclosure Vulnerability
Excel update package
PowerPoint
PowerPoint update package
Outlook
Outlook update package
Microsoft AutoUpdate 4.2
CVE-2018-8412: Microsoft AutoUpdate Office Elevation of Privilege Vulnerability
Office suite

July 2018 release

Release Date: July 10, 2018

Version 16.15.0 (Build 18070902)

This release provides the following updates.

ApplicationFeatures updatesSecurity updatesDownload link for update package
Word
Word update package
Excel
Excel update package
PowerPoint
Pep up your pitch with video: Add live action to your slide with a YouTube video, and then view it without having to leave the app. Learn more
PowerPoint update package
Outlook
Improved security for Google accounts: Security improvements mean that you no longer need to allow access to 'less secure apps' or set an app password in order to add your Google Account to Outlook. Learn more
Outlook update package
Microsoft AutoUpdate 4.1
Update to Aria SDK 8.4. Fixes memory leak issue.
Changes to App Registration. Now supports Office 2019 Preview.
Office suite
CVE-2018-8281: Microsoft Office Remote Code Execution Vulnerability

Excel For Mac 2018 If Then Find String Length

June 2018 release

Release Date: June 13, 2018

Version 16.14.1 (Build 18061302)

This release fixes an issue with the updater packages for the individual applications.

Release Date: June 12, 2018

Version 16.14.0 (Build 18061000)

This release provides the following updates.

ApplicationFeatures updatesDownload link for update package
Word
Learning Tools improve readability: Give your eyes a rest. Adjust text spacing, column width, and page color. Or listen as Word reads your document aloud, highlighting text as it's read. Learn more
Excel
Fill data in a flash: Give Flash Fill a few examples, and it will fill your data for you. Learn more
Break the language barrier: Translate words, phrases, or sentences in another language with Microsoft Translator. Learn more
PowerPoint
Break the language barrier: Translate words, phrases, or sentences in another language with Microsoft Translator. Learn more
Hyperlinks in living colors: Hyperlinks aren't just blue anymore. Apply any font color you like. Learn more
Outlook
Create a signature they'll remember: Express yourself with rich font styles, colors, images, links, and more. Learn more
Create and collaborate with Groups: Want to create an Office 365 Group in Outlook? No problem! Add and remove members, too. Collaboration on the Mac just got easier. Learn more
Microsoft AutoUpdate 4.0

May 2018 release

Release Date: May 24, 2018

Version 16.13.1 (Build 18052304)

This release fixes an issue with diagnostic data settings.

Here are the download links for the update packages: Word, Excel, PowerPoint, Outlook, and OneNote.


Release Date: May 23, 2018

Version 16.13.1 (Build 18052203) *

This release includes a General Data Protection Regulation (GDPR) compliant end user notification.

*The build number for Outlook is 18052301.


Release Date: May 15, 2018

Version 16.13.0 (Build 18051301)

This release provides the following updates.

ApplicationFeatures updatesSecurity updatesDownload link for update package
Word
Chat with co-authors while you edit: Collaborate more effectively by chatting with your co-authors without ever leaving Word. Learn more
Insert and edit icons: Use icons to add visual impact to your document by inserting and editing one of 500 icons. Learn more
Write your best resume or CV with help from LinkedIn: Resume Assistant shows you work experiences, top skills, and more for a given role. Find it on the Review tab. Learn more
Accessibility built right in: Use your keyboard to access the ribbon quickly and to format the words or pictures you just inserted.
Excel
Chat with co-authors while you edit: Collaborate more effectively by chatting with your co-authors without ever leaving Excel. Learn more
Insert and edit icons: Use icons to add visual impact to your workbook by inserting and editing one of 500 icons. Learn more
Use a timeline to filter your data: Easily filter a PivotTable by sliding the date range with a timeline filter. Learn more
CVE-2018-8147: Microsoft Excel Remote Code Execution Vulnerability
CVE-2018-8162: Microsoft Excel Remote Code Execution Vulnerability
PowerPoint
Chat with co-authors while you edit: Collaborate more effectively by chatting with your co-authors without ever leaving PowerPoint. Learn more
Insert and edit icons: Use icons to add visual impact to your presentation by inserting and editing one of 500 icons. Learn more
CVE-2018-8176: Microsoft PowerPoint Remote Code Execution Vulnerability
Outlook
Customize swipe gestures: Set the swipe left and swipe right gestures to the actions you use most. Choose from Delete, Archive, Mark as Read, Flag, or None. Learn more
Support for Google Calendar and Contacts: Manage your Google Calendar and Contacts without leaving Outlook.* Learn more
*This feature is being rolled out to Office 365 subscribers over a period of time, so you might not see this feature right away.
Microsoft AutoUpdate 4.0

April 2018 release

Release Date: April 11, 2018

Version 16.12.0 (Build 18041000)

This release provides the following updates.

ApplicationFeatures updatesSecurity updatesNon-security updatesDownload link for update package
Word
Better sharing and collaboration: Your locally synced OneDrive documents open directly from the cloud, allowing you to AutoSave, share, and collaborate easily.
Add visual impact: Insert and edit Scalable Vector Graphics (SVGs) in your documents to add visual interest and retain a high image quality. Learn more
Excel
Better sharing and collaboration: Your locally synced OneDrive workbooks open directly from the cloud, allowing you to AutoSave, share, and collaborate easily.
Add visual impact: Insert and edit Scalable Vector Graphics (SVGs) in your workbooks to add visual interest and retain a high image quality. Learn more
CVE-2018-1029: Microsoft Excel Remote Code Execution Vulnerability
PowerPoint
Better sharing and collaboration: Your locally synced OneDrive presentations open directly from the cloud, allowing you to AutoSave, share, and collaborate easily.
Add visual impact: Insert and edit Scalable Vector Graphics (SVGs) in your presentations to add visual interest and retain a high image quality. Learn more
Outlook
Add visual impact: Insert and edit Scalable Vector Graphics (SVGs) in your emails to add visual interest and retain a high image quality. Learn more
A more actionable calendar: Click any meeting or event in your calendar to see all of the associated details. Check out who is invited, edit your response, or join the meeting, all in one place.
Easier scanning of search results: Outlook highlights your search term in the item list or Preview pane.
Week numbers: Week numbers are now displayed in Calendar month view and mini-calendar in the sidebar. To enable, check 'Show week numbers' in Outlook > Preferences > Calendar > Calendar options.
Scheduling Skype meetings: Delegates can now schedule Skype for Business Online meetings on behalf of principals using principals' email addresses. (Skype for Business Online only. This will be enabled for Skype for Business Server 2015 in a future server update.)
Improved error handling when editing and deleting server rules. Server rules containing errors are now highlighted when first displayed in the rules list.
OneNote
Microsoft AutoUpdate 3.18
Support for the msupdate command-line tool. Learn more

March 2018 release

Release Date: March 19, 2018

Version 16.11.1 (Build 18031900)

This release fixes an issue where Word, Excel, and PowerPoint occasionally become indefinitely unresponsive on launch.


Release Date: March 13, 2018

Version 16.11.0 (Build 18031100)

This release provides the following updates.

ApplicationFeatures updatesSecurity updatesNon-security updates
Word
Do more with Focus Mode: Focus Mode now opens at your set zoom level and shows the page number while you scroll.
Excel
CVE-2018-0907: Microsoft Office Excel Security Feature Bypass
PowerPoint
Embedded fonts: Embedded fonts ensure that your presentation looks the same on every computer and people experience your content as you intend.
Outlook
Tables: Insert tables in your messages and calendar events, and bring structure to your content. No more copying and pasting from other Office apps. Learn more
View two time zones at once: Want to know what time it is in another part of the world? Now you can add a second time zone to Outlook .
Schedule across time zones: Traveling across time zones? Create an event with different start and end time zones, and Outlook will take care of the conversion.
Change text size: Increase or decrease the font size in your sidebar, message list, and reading pane. Learn more
Fix an issue, where if the default time zone for your computer observes daylight saving time (DST) and Week view is selected, you may see that all events are shifted by one hour on the calendar grid on the week when DST starts.
Office suite
CVE-2018-0919: Microsoft Office Information Disclosure Vulnerability

February 2018 release

Release Date: February 13, 2018

Version 16.10.0 (Build 18021001)

This release provides the following updates.

ApplicationFeatures updatesNon-security updates
Excel
Precision selecting: Ever selected too many cells or the wrong ones? You can now deselect extraneous cells without having to start over. Learn more
Slice and dice your table data: You loved slicers for PivotTables. You can now use them in tables too to see exactly what filters you have applied. Learn more
PowerPoint
Shine the light on what matters: Grab the new highlighter to flag important information. Learn more
Microsoft AutoUpdate 3.16
Fix an issue with UpdateCache failover to the Office Content Delivery Network (CDN).

January 2018 release

Release Date: January 26, 2018

Version 16.9.1 (Build 18012504)

This release addresses compatibility issues in Word and PowerPoint with some third-party fonts or in mixed-language environments.


Release Date: January 18, 2018

Version 16.9.0 (Build 18011602)

This release provides the following updates.

ApplicationFeatures updatesSecurity updates
Word
Edit with others in real time: Thumbnails in the upper-right corner of the window show who else is working with you in a shared document. Flag icons show where others are working and you can view changes as they type. Learn more
We save for you! Changes are saved automatically for documents, worksheets, and presentations stored in the cloud, and you can see others' updates in seconds. Need to roll back? Check the version history for a list of changes and access to earlier versions. Learn more
Quickly access your sites and groups: Quickly find presentations stored in your frequently used sites and groups in the Open menu.
CVE-2018-0792: Microsoft Word Remote Code Execution Vulnerability
CVE-2018-0794: Microsoft Word Remote Code Execution Vulnerability
Excel
Collaborative editing: Work with others at the same time in your workbook. Thumbnails in the upper-right corner of the window show who else is viewing or editing the file with you. Learn more
We save for you! Changes are saved automatically for documents, worksheets, and presentations stored in the cloud, and you can see others' updates in seconds. Need to roll back? Check the version history for a list of changes and access to earlier versions. Learn more
More charts: Use new charts, such as funnel, sunburst and histogram, to transform your data into professional visualizations, or use the new Map chart type to transform geographic data into a map with just a few steps.
More functions: Shorten the formulas you write using the new logical functions IFS function and SWITCH function.
Quickly access your sites and groups: Quickly find presentations stored in your frequently used sites and groups in the Open menu.
Better support for PivotTable charts: Change your filters in a PivotTable, and the chart you created will automatically adjust to show exactly what you want.
Multi-threaded calculation Formulas are updated faster when values are changed, because Excel uses multiple processing threads.
PowerPoint
Edit with others in real time: Thumbnails in the upper-right corner of the window show who else is working with you in a shared document. Flag icons show where others are working and you can view changes as they type. Learn more
We save for you! Changes are saved automatically for documents, worksheets, and presentations stored in the cloud, and you can see others' updates in seconds. Need to roll back? Check the version history for a list of changes and access to earlier versions. Learn more
See what's changed: Slides that have been modified by others while you were away are highlighted. Learn more
A quick start to your research: Starting from scratch is hard. QuickStarter automatically creates an outline for your topic of choice with suggested talking points and designs that make your presentation pop. Learn more
Trim media: Remove unwanted content from the beginning or end of an audio or video clip. Learn more
Quickly access your sites and groups: Quickly find presentations stored in your frequently used sites and groups in the Open menu.
Laser pointer in Slide Show: Use your mouse as a laser pointer to draw attention to certain parts of your slide.
Text Highlighter: Text highlight is now on Mac! Use text highlighter to emphasize important pieces of text.
Outlook
Archive or delete with just one swipe: Save time organizing your Inbox by swiping left with two fingers across the touchpad to archive an email or swiping right to delete it.
CVE-2018-0793: Microsoft Outlook Remote Code Execution Vulnerability

December 2017 release

Release Date: December 17, 2017

This release fixes an issue with Microsoft AutoUpdate (MAU) offering an incorrect version update.


Release Date: December 12, 2017

Version 15.41.0 (Build 17120500)

This release provides the following updates.

ApplicationSecurity updates
PowerPoint
CVE-2017-11934: Microsoft PowerPoint Information Disclosure Vulnerability

November 2017 release

Release Date: November 14, 2017

Version 15.40.0 (Build 17110800)

This release provides the following updates.

ApplicationSecurity updates
Word
Advisory 170020: Microsoft Office Defense in Depth Update
Excel
CVE-2017-11877: Microsoft Excel Security Feature Bypass Vulnerability

October 2017 release

Release Date: October 10, 2017

Version 15.39.0 (Build 17101000)

This release provides the following updates.

ApplicationFeature updatesSecurity updates
Word
Improved Visual Basic Editor: Create and edit macros in the Visual Basic Editor using IntelliSense, VBA menus and toolbars, debug tools, an object browser, and more.
Excel
Improved Visual Basic Editor: Create and edit macros in the Visual Basic Editor using IntelliSense, VBA menus and toolbars, debug tools, an object browser, and more.
PowerPoint
Improved Visual Basic Editor: Create and edit macros in the Visual Basic Editor using IntelliSense, VBA menus and toolbars, debug tools, an object browser, and more.
Outlook
Improved readability and accessible, too: Your email message and meeting invitation headers are now easier on the eyes. Less clutter, better keyboard navigation, and improved VoiceOver.
Office suite
CVE-2017-11825: Microsoft Office Remote Code Execution Vulnerability

September 2017 release

Release Date: September 12, 2017

Version 15.38.0 (Build 17090200)

This release provides the following updates.

ApplicationFeature updatesSecurity updates
Excel
CVE-2017-8631: Microsoft Office Memory Corruption Vulnerability
CVE-2017-8632: Microsoft Office Memory Corruption Vulnerability
Office suite
CVE-2017-8676: Windows GDI+ Information Disclosure Vulnerability
Microsoft AutoUpdate 3.9.3
Alerts users to re-install MAU when missing or broken components are detected.

August 2017 release

Release Date: August 15, 2017

Version 15.37.0 (Build 17081500)

This release provides the following updates.

ApplicationFeature updates
Word
Researcher: Find relevant quotes, citable sources, and images without leaving Word. Learn more
Safe links: When a user clicks on a link, Office 365 Advanced Threat Protection (ATP) inspects the link to see if it's malicious. If the link is deemed malicious, the user is redirected to a warning page instead of the original target URL. Learn more
Excel
Safe links: When a user clicks on a link, Office 365 Advanced Threat Protection (ATP) inspects the link to see if it's malicious. If the link is deemed malicious, the user is redirected to a warning page instead of the original target URL. Learn more
PowerPoint
Safe links: When a user clicks on a link, Office 365 Advanced Threat Protection (ATP) inspects the link to see if it's malicious. If the link is deemed malicious, the user is redirected to a warning page instead of the original target URL. Learn more

July 2017 release

Release Date: July 21, 2017

Version 15.36.1 (Build 17072101)

This release fixes an issue with Outlook keeping group messages up to date.


Release Date: July 11, 2017

Version 15.36.0 (Build 17070201)

This release provides the following updates.

ApplicationFeature updatesSecurity updates
Excel
Pictures in headers and footers: Customize your printed workbooks by adding images to headers and footers.
Outlook
Send email on your schedule: Delay the delivery of a message or choose when it will be sent. Learn more
All your favorite folders in one place: Create shortcuts to all the folders you use regularly. All shortcuts are listed in Favorites at the top of your Sidebar. Learn more
Format Painter: Available when creating emails, events, and tasks.
Office suite
CVE-2017-8501: Microsoft Office Memory Corruption Vulnerability

June 2017 release

Release Date: June 16, 2017

Version 15.35.0 (Build 17061600)

This release fixes an issue where OneNote crashes when creating a new page with templates.


Release Date: June 13, 2017

Version 15.35.0 (Build 17061000)

This release provides the following updates.

ApplicationFeature updatesSecurity updates
Word
CVE-2017-8509: Microsoft Office Remote Code Execution Vulnerability
Outlook
Spend less time writing emails: Create an email template and reuse it later to save time. Learn more
Request Read Receipts and Delivery Notifications: Get notified when your important email messages have been delivered to and opened by recipients. Learn more
Easier account setup: Now, when you add an Exchange or Gmail account, settings are updated for you. Just provide your username and password, and you are good to go. Learn more

May 2017 release

Release Date: May 16, 2017

Version 15.34.0 (Build 17051500)

This release provides the following updates.

ApplicationFeature updatesSecurity updates
Word
Modern backgrounds for Focus Mode: Choose from Twilight or Polar Night backgrounds, when you're in Focus Mode on the View tab. Learn more
Dubai font: Font family that supports both Western European languages as well as the major languages that use the Arabic script. Learn more
Excel
Dubai font: Font family that supports both Western European languages as well as the major languages that use the Arabic script. Learn more
PowerPoint
Dubai font: Font family that supports both Western European languages as well as the major languages that use the Arabic script. Learn more
Outlook
Groups: View your top 10 groups, and read or reply to group conversations directly from the Groups folder.
Dubai font: Font family that supports both Western European languages as well as the major languages that use the Arabic script. Learn more
Office suite
CVE-2017-0254: Microsoft Office Memory Corruption Vulnerability


Release Date: May 9, 2017

This release provides the following updates.

ApplicationNon-security updates
Microsoft AutoUpdate 3.9.1
- Fix a critical issue that prevents automatic update notifications when 'Automatically Check' is selected.
- Fix an issue where AutoUpdate crashes on OS X 10.10.
- Fix an issue where apps won't launch if an update is pending.
Important: If you updated to Microsoft AutoUpdate 3.9.0, and you have your AutoUpdate settings set to 'Automatically Check,' then you will need to manually update to Microsoft AutoUpdate 3.9.1 by using either of the following methods:
- Go to Help > Check for Updates, and then choose Check for Updates.
- Go to Help > Check for Updates, and then select Automatically Download and Install.

April 2017 release

Release Date: April 11, 2017

Version 15.33.0 (Build 17040900)

This release provides the following updates.

ApplicationFeature updates
Microsoft AutoUpdate
- Support for Suite Delta Updates, which will reduce the monthly update size by 50%.
- Support for MAU self-updates, where MAU can update itself without requiring admin credentials.
This version of MAU isn't available to download.

March 2017 release

Release Date: March 14, 2017

Version 15.32.0 (Build 17030901)

This release provides the following updates.

ApplicationFeature updatesSecurity updates
Excel
Microsoft Security Bulletin MS17-014: Security Update for Microsoft Office (3217868)
Outlook
Touch Bar support: The most relevant commands to what you're working on are at your fingertips. (Only compatible with MacBook Pro with Touch Bar.)
Translator add-in: Translate email without leaving Outlook. Just turn on the Translator add-in to translate with a single tap. Choose from 60 languages. Learn more
Install the add-in from the Office Store
Access more features right from your Inbox: Add-ins for Outlook let you create tasks with Wunderlist, track email responses with Boomerang, and more. Learn more
Office suite
Microsoft Security Bulletin MS17-014: Security Update for Microsoft Office (3217868)

February 2017 release

Release Date: February 16, 2017

Version 15.31.0 (Build 17021600)

This release provides the following updates.

ApplicationFeature updatesNon-security updates
Word
Touch Bar support: The most relevant commands to what you're working on are at your fingertips. (Only compatible with MacBook Pro with Touch Bar.)
Excel
Touch Bar support: The most relevant commands to what you're working on are at your fingertips. (Only compatible with MacBook Pro with Touch Bar.)
PowerPoint
Touch Bar support: The most relevant commands to what you're working on are at your fingertips. (Only compatible with MacBook Pro with Touch Bar.)
Microsoft AutoUpdate
Version number updated to 3.8.4.

January 2017 release

Release Date: January 11, 2017

Version 15.30.0 (Build 17010700)

This release provides the following updates.

ApplicationFeature updatesNon-security updates
Word
Additional focus mode choices, including Oak, Mahogany, and Graphite. For Office 365 subscribers only. Learn more
Fix various performance issues, such as typing or scrolling lags and slow performance when editing a large document.
Microsoft AutoUpdate
Additional logging and troubleshooting capabilities.
Version number updated to 3.8.3.

December 2016 release

Release Date: December 15, 2016

Version 15.29.1 (Build 16121500)

This release fixes an issue with opening or saving files in Word, Excel, or PowerPoint when the first part of the file path contains spaces or certain characters.


Release Date: December 13, 2016

Version 15.29.0 (Build 16120900)

This release provides the following updates.

ApplicationFeature updatesNon-security updatesSecurity updates
Word
Retain your document fidelity, with working hyperlinks, when converting to PDF. Learn more
Improved support for creating accessible documents and using VoiceOver and other assistive technology to read and edit documents. Learn more
Excel
Improved support for creating accessible documents and using VoiceOver and other assistive technology to read and edit documents. Learn more
Fix an issue where, when using Data Validation, if you enter text into the error message box, Excel crashes.
Microsoft Security Bulletin MS16-148: Security Update for Microsoft Office (3204068)
PowerPoint
Improved support for creating accessible documents and using VoiceOver and other assistive technology to read and edit documents. Learn more
Office suite
Support for three additional languages: Greek, Hungarian, and Slovak
Microsoft Security Bulletin MS16-148: Security Update for Microsoft Office (3204068)
Microsoft AutoUpdate
- Version number updated to 3.8.2.
- Improved reliability and minor bug fixes.
Microsoft Security Bulletin MS16-148: Security Update for Microsoft Office (3204068)

November 2016 release

Release Date: November 17, 2016

Version 15.28.0 (Build 16111700)

This release fixes an issue with Outlook and public folders on Exchange Server 2010.


Release Date: November 15, 2016

Version 15.28.0 (Build 16111501)

This release fixes an issue with the update packages for the individual applications.


Release Date: November 15, 2016

Version 15.28.0 (Build 16111300)

This release provides the following updates.

ApplicationFeature updatesNon-security updatesSecurity updates
Word
New grammar support for Czech, Hungarian, Korean, Norwegian, Polish, Russian and Turkish.
Fix an issue where Word fails to save documents when Excel spreadsheets with certain border content is embedded into the document.
Microsoft Security Bulletin MS16-133: Security Update for Microsoft Office (3199168)
Excel
Fix a long-running issue where Excel fails to save changes on certain enterprise storage configurations such as NetApp FAS units. Excel now adopts the same file saving pattern as Word.
Microsoft Security Bulletin MS16-133: Security Update for Microsoft Office (3199168)
PowerPoint
View interactive summaries and automatic navigation links that were created using the Zoom command in PowerPoint 2016 for Windows.
Fix an issue where images don't render and are replaced with an error referring to rID#.
Outlook
Find and fix accessibility issues that occur when composing messages or invitations by using the Accessibility Checker. Learn more
Fix an issue with automatic language detection when composing emails.
Office suite
- Significant improvements for users with accessibility needs.
- Microsoft Error Reporting can be configured to save the last crash log to disk (defaults write com.microsofterrorreporting IsStoreLastCrashEnabled -bool TRUE).
- Better activation message for E1/K1 users. No longer suggests to users that an error occurred and welcomes them to the view-only experience.
- Installer and updater file name format change. For example, Microsoft_Office_2016_15.28.16111300_Installer.pkg instead of Microsoft_Office_2016_15.28.0_161113_Installer.pkg.
Microsoft AutoUpdate
Includes a new option to automatically detect, download, and install updates.
- Version number updated to 3.8.1.
- Fix an issue where MAU can crash when older versions of Microsoft Silverlight are installed, specifically when Silverlight is registered with a null LCID.
- Fix an issue where MAU can crash when using the ManifestServer preference.
- Microsoft AU Daemon bundle display name changed to 'Microsoft Update Assistant.'
- MAU XML feed for 2016 apps no longer include a Triggers dictionary and relies on 'Update Version' for version detection.
- MAU now shows the complete version string in the app update window. For example, 15.28.16110300 instead of just 15.28.