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.

Examples. Example 1. This example uses SORT and UNIQUE together to return a unique list of names in ascending order. Example 2. This example has the exactly_once argument set to TRUE, and the function returns only those customers who have had service one time.

Safe senders and recipients. Safe senders are people and domains you always want to receive email messages from. Safe recipients are recipients that you don't want to block, usually groups that you’re a member of.

Microsoft 365 for business If your business subscription plan includes the desktop version of the Microsoft 365 apps you won't see an option to install it unless someone in your organization assigned a license to you.. Learn how to check this in What Microsoft 365 business product or license do I have? or if you're a Microsoft 365 admin responsible for assigning licenses to people in your ...

Tip: If you're using a wireless display adapter, connect to an HDMI port on newer TVs, then wirelessly connect your PC to it.After connecting your wireless display adapter to your TV, go to your Windows 11 PC, press Windows logo key + K to open Cast, then select your wireless display adapter.

Items restored from Recoverable Items go to the Deleted Items folder. When you recover items from the Recoverable Items folder, they are moved to the Deleted Items folder. After you recover an item, you can find it in your Deleted Items folder and then you can move it to another folder.. Tips and Troubleshooting

Contact Microsoft Support. What's new. Surface Pro; Surface Laptop; Surface Laptop Studio 2

Use Version History to view previous versions of files stored in OneDrive or SharePoint libraries.

If you don’t want to use the proxy server when you visit certain websites, enter the ending of the website address in the exception list (for example, *.contoso.com). For multiple websites, type each website address and separate the addresses with a semicolon (for example: *.contoso.com; *.adatum.com).The * is a wildcard so any website addresses that end with the website address listed will ...

Alternate command key. What it does. Help. Opens the Help system (if any) for the active window. Undo. Cancels the previous action. Redo. Cancels the previous Undo action.