This article describes the formula syntax and usage of the SUBSTITUTE function in Microsoft Excel.. Description. Substitutes new_text for old_text in a text string. Use SUBSTITUTE when you want to replace specific text in a text string; use REPLACE when you want to replace any text that occurs in a specific location in a text string.

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

If the battery is drained, and the charger you’re using is 60W or higher, your Surface will instantly turn on when you plug it in. If you’re using a charger that uses less than 60W, your Surface must charge to 10% before it will turn on.

Insert rows. To insert a single row: Right-click the whole row above which you want to insert the new row, and then select Insert Rows. To insert multiple rows: Select the same number of rows above which you want to add new ones.Right-click the selection, and then select Insert Rows.. Insert columns. To insert a single column: Right-click the whole column to the right of where you want to add ...

The Office app is running in the background. If the file is not shared on a network or if you are certain that no one is currently editing it, then an instance of the Office app with the file open might be running in the background.

In Outlook, the black color theme includes dark mode, which provides a black background (instead of white) for the message window. You can switch to a white background for the message window if you prefer.

Disable all macros except digitally signed macros Macros are disabled, and security alerts appear if there are unsigned macros present.However, if the macro is digitally signed by a trusted publisher, the macro just runs. If the macro is signed by a publisher you haven't trusted yet, you are given the opportunity to enable the signed macro and trust the publisher.

Note: If you signed in with a Microsoft account such as an Outlook.com, Hotmail, Live, or MSN email account instead of your work or school account, sign out, and then sign in again using the correct account. Not sure which account you're signed in with? Select Account manager in the Outlook navigation header. If you're not signed in with the account you want, select Sign out and start the ...

To turn it off, switch the setting to Off.. Turning off Microsoft Defender Firewall could make your device (and network, if you have one) more vulnerable to unauthorized access.

If pressing the Connect button in action center doesn't find your device in Windows 10, here are some things to try:. Check action center to see if your Windows device supports Bluetooth. If it does, there'll be a Bluetooth button in action center. Make sure it's turned on.