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.

Learn how to troubleshoot File Explorer problems in Windows. To open File Explorer in Windows 10, select its icon on the taskbar, press the Windows logo key + E on your keyboard, or select Start > Documents (directly beneath your user icon).. Here are some things to try if File Explorer won't open.

Устранение неполадок с аксессуарами Bluetooth. Если вы можете включить Bluetooth, но у вас возникают проблемы со связыванием или использованием аксессуара Bluetooth, см. следующие действия, которые помогут вам устранить ...

The Teams Meeting add-in lets you schedule a Teams meeting from Outlook. The add-in is available for Outlook on Windows, Mac, web, and mobile, and should be automatically installed if you have Microsoft Teams and either Office 2016, Office 2019, or Office 2021 installed on your Windows PC.

Problem. Description. Quotation marks appear in result string. Use commas to separate adjoining text items. For example: Excel will display =CONCATENATE("Hello ""World") as Hello"World with an extra quote mark because a comma between the text arguments was omitted.

After you send an email message, you might want to find that email and resend it or forward it to someone else. Outlook stores your messages in the Sent Items folder.If you don't see the Sent Items folder, you may need to change your Outlook settings.. You can find your Sent Items folder in your folder list.

After you create your drop-down list, make sure it works the way you want. For example, you might want to check to see if Change the column width and row height to show all your entries.. If the list of entries for your drop-down list is on another worksheet and you want to prevent users from seeing it or making changes, consider hiding and protecting that worksheet.

Import a text file by opening it in Excel. You can open a text file that you created in another program as an Excel workbook by using the Open command. Opening a text file in Excel does not change the format of the file — you can see this in the Excel title bar, where the name of the file retains the text file name extension (for example, .txt or .csv).

New or classic Outlook for Windows desktop apps Classic Outlook for Windows is a desktop app included with Microsoft 365 Personal or Family subscriptions or non-subscription versions of Office such as Office Home & Business. New Outlook for Windows is available free on Windows devices or as a free download.If you don't already have new Outlook, you can download it from the Microsoft Store ...