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

The CONCAT function combines the text from multiple ranges and/or strings, but it doesn't provide delimiter or IgnoreEmpty arguments. CONCAT replaces the CONCATENATE function.However, the CONCATENATE function will stay available for compatibility with earlier versions of Excel.

Tasks stores tasks that you create or that are sent to you, and also messages that you’ve flagged. When you view your tasks, the default view is Flagged Items and Tasks.You can change that by selecting Tasks in the folder list to the left. For more information about tasks in Outlook Web App, go to Tasks Overview.. Create a new task by selecting New task.

An array formula (one that spans multiple cells) can do calculations on rows and columns of cells where you might otherwise need to use several formulas. For example, you can count the number of characters that are contained in a range of cells, sum only numbers that meet certain conditions (such as the lowest values in a range or numbers that fall between an upper and lower boundary), and sum ...

Once you've allowed microphone access to your apps, you can change the settings for each app. In Microphone settings, go to Choose which Microsoft apps can access your microphone, and turn on apps you want to use with it.For desktop apps, make sure that Allow desktop apps to access your microphone is turned on.

If you can't sign into your Microsoft account, most issues can be identified by our sign-in helper tool. The tool will ask you to enter the email address or mobile phone number you're trying to sign in with and check the details you provide.

Change display name. You use your display name whenever you sign in to your account. You'll also see it on any Windows devices that you've signed into with your Microsoft Account, and it's the name people see when you send emails or participate in an Outlook.com group.

Note: If you see the icon next to the On/Off toggle for an app, you can select it to see the registry location that contains the path for the app. Apps installed through Microsoft Store (.MSIX apps) don’t have these icons. If you select the icon for these apps, File Explorer opens and highlights the executable file.

Unlinking and re-linking your computer to OneDrive can help solve some sync problems. You can also use these same steps to move your OneDrive to a new location, such as an external disk drive.

To find Sync settings, select Start , then select Settings > Accounts > Sync your settings . Choose from settings such as language preferences, passwords, and color themes. If you turn on Other Windows settings, Windows also syncs some device settings (for things like printers and mouse options), File Explorer settings, and notification preferences.