Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
Text functions (reference) - Microsoft Support
Returns text that occurs after given character or string. TEXTBEFORE function. Returns text that occurs before a given character or string. TEXTJOIN function. Combines the text from multiple ranges and/or strings. TEXTSPLIT function. Splits text strings by using column and row delimiters. TRIM function. Removes spaces from text. UNICHAR function
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel 2013
DDE Function - Microsoft Support
A string expression identifying an application that can participate in a DDE conversation. Usually, application is the name of an .exe file (without the .exe extension) for a Microsoft Windows–based application, such as Excel.
Applies To: Access for Microsoft 365, Access 2021, Access 2019, Access 2016, Access 2013
How to use the Regsvr32 tool and troubleshoot Regsvr32 error messages
Regsvr32 is a command-line utility to register and unregister OLE controls, such as DLLs and ActiveX controls in the Windows Registry. Regsvr32.exe is installed in the %systemroot%\System32 folder in Windows XP and later versions of Windows.
Use the System File Checker tool to repair missing or corrupted system ...
Swipe in from the right edge of the screen, and then tap Search.Or, if you are using a mouse, point to the lower-right corner of the screen, and then click Search.Type Command Prompt in the Search box, right-click Command Prompt, and then click Run as administrator.If you are prompted for an administrator password or for a confirmation, type the password, or click Allow.
Remove specific prevalent malware with Windows Malicious Software ...
Microsoft generally releases the MSRT on a monthly cadence as part of Windows Update or as a standalone tool. (For exceptions, see Skipped releases.)Use this tool to find and remove specific prevalent threats and reverse the changes that they made (see Covered malware families).For comprehensive malware detection and removal, consider using Windows Defender Offline or Microsoft Safety Scanner.
Repair Outlook Data Files (.pst and .ost) - Microsoft Support
All Outlook Data Files (.pst) and Offline Data Files (.ost) are listed along with the name of the account the files are associated with. If you cannot open your Outlook data file or suspect that the file is damaged, use the Inbox Repair tool (scanpst.exe) to repair errors in the file.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
Choose language settings for your keyboard, websites, and apps
Adding an input language lets you set a language-preference order for websites and apps. It also lets you change your keyboard language. Select Start > Settings > Time & language > Language & region. Under Preferred languages, select the language that contains the keyboard you want, and then select Options. Select Add a keyboard and choose the ...
SUBSTITUTE function - Microsoft Support
TRIM function. 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.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
Description of Microsoft System Information (Msinfo32.exe) Tool
Windows includes a tool called Microsoft System Information (Msinfo32.exe). This tool gathers information about your computer and displays a comprehensive view of your hardware, system components, and software environment, which you can use to diagnose computer issues.
String functions and how to use them - Microsoft Support
With string functions, you can create expressions in Access that manipulate text in a variety of ways. For example, you might want to display only part of a serial number on a form. Or, you might need to join (concatenate) several strings together, such as a last name and a first name.
Applies To: Access for Microsoft 365, Access 2021, Access 2019, Access 2016