Important: In Excel 2016, Excel Mobile, and Excel for the web, this function has been replaced with the CONCAT function.Although the CONCATENATE function is still available for backward compatibility, you should consider using CONCAT from now on. This is because CONCATENATE may not be available in future versions of Excel.

Problem. Description. 0 (Zero) is shown instead of the expected result. Make sure Criteria1,2 are in quotation marks if you are testing for text values, like a person's name.. The result is incorrect when Sum_range has TRUE or FALSE values.. TRUE and FALSE values for Sum_range are evaluated differently, which may cause unexpected results when they're added. ...

Important: Workbook links are considered potentially unsafe and must be enabled when you open a formula workbook.When you open a formula workbook, click Enable Content in the Message Bar to allow the workbook links to function. If you don't, Excel keeps the most recent values and disables refreshing the links with values from the data workbook.

Note: To create an email message using a keyboard shortcut, press Ctrl + Shift + M.

When you sign in to sync to Microsoft Edge , you can easily browse the web from any of your devices, keep your favorites organized, and always pick up right where you left off.. Sign in to sync your account on your computer Setting up sync on your computer. In Microsoft Edge, select the profile image in the browser taskbar.

Resolve Windows blue screen errors with tips and resources to do your own troubleshooting, or contact the Microsoft support if you need more help.

Hvis du vil have support på Outlook.com, skal du klikke her eller vælge Hjælp på menulinjen og angive forespørgslen. Hvis du ikke selv kan løse dit problem, skal du rulle ned til Har du stadig brug for hjælp? og vælge Ja.. Hvis du vil kontakte os på Outlook.com, skal du logge på.

Select Review activity to check for any unusual sign-in attempts on the Recent activity page.If you see account activity that you're sure wasn't yours, let us know and we can help secure your account—if it's in the Unusual activity section, you can expand the activity and select This wasn't me.If it's in the Recent activity section, you can expand the activity and select Secure your account.

A manager needs an assistant to monitor email on his or her behalf. In this scenario, an assistant is granted the appropriate permissions to a manager’s folder or mailbox, but when they respond to messages, their responses are shown as coming on behalf of the manager.This type of sharing requires Delegate access permissions. For help with setting up delegate permissions, see Allow messages ...

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.