Note: If you have a current version of Microsoft 365, then you can input the formula in the top-left-cell of the output range, then press ENTER to confirm the formula as a dynamic array formula. Otherwise, the formula must be entered as a legacy array formula by first selecting the output range, input the formula in the top-left-cell of the output range, then press CTRL+SHIFT+ENTER to confirm it.

Splits text strings by using column and row delimiters. The TEXTSPLIT function works the same as the Text-to-Columns wizard, but in formula form.It allows you to split across columns or down by rows.

On your console, get Xbox Game Pass Ultimate in Store > Subscriptions.Online, go to Xbox Game Pass. Your purchase of Game Pass Ultimate will automatically convert any outstanding time on your subscriptions to Xbox Game Pass or EA Play into time for Xbox Game Pass Ultimate at the current conversion ratio, up to a maximum of 36 months.

Add your Outlook.com, Microsoft 365, Exchange-based email, or IMAP or POP email account to your Android phone or tablet using the built-in Android Email app.

Notes: You don't need a smartphone to receive a security code. Text messages may come from either "MSFT", a short number, or a mobile number.If you have requested a security code, you can trust the message that arrives.

An upgrade moves your PC from a previous version of Windows—such as Windows 7 or Windows 8.1—to Windows 10. An upgrade can take place on your existing device, though Microsoft recommends using Windows 10 on a new PC to take advantage of the latest features and security improvements.

After you update a drop-down list, make sure it works the way you want. For example, check to see how to Change the column width and row height to show your updated 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.

On the PC you’re sharing from, select Start , and then select Settings > System > Nearby sharing .Choose whether you’d like to be able to share and receive files with everyone, or only your own devices (where you are logged in with your Microsoft account).

Note: If you are in tablet mode, desktop icons are not displayed.To see your desktop icons in tablet mode, go to Start > Settings > System > Tablet, then select Change additional tablet settings.Under When I'm using tablet mode, make sure that Hide app icons on the taskbar and Automatically hide the taskbar are both set to Off.

Microsoft support is here to help you with Microsoft products. Find how-to articles, videos, and training for Microsoft Copilot, Microsoft 365, Windows, Surface, and more.