When you need to count the characters in cells, use the LEN function—which counts letters, numbers, characters, and all spaces. For example, the length of "It's 98 degrees today, so I'll go swimming" (excluding the quotes) is 42 characters—31 letters, 2 numbers, 8 spaces, a comma, and 2 apostrophes.

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.

Get started with basic tasks in Excel such as opening a workbook, entering and formatting data, calculating data, and trying some quick analysis features..

This content can help you with your work or school account, which is the account provided to you by your organization (for example, dritan@contoso.com).

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.

To change appearance, select Appearance and make the changes you want to your default theme, zoom, toolbar, and fonts.

Choose number of pages to print per sheet: Printing multiple pages on a single sheet of paper is a useful technique to save paper, reduce printing costs, and create compact versions of your documents. The number of pages that can be printed on a single sheet depends on the capabilities of your printer and the printing options you choose (Example: 1, 2, 4, 6, 9 or 16 pages per sheet).

A family group is a set of individuals connected through the Microsoft Family Safety app on their Windows, Xbox, or mobile devices. Establishing a family group is an easy, effective way to encourage healthy online habits and manage busy schedules.

Find everything you need to manage your Xbox account, profile, and more.

When you delete an online-only file from your device, you delete it from your OneDrive on all devices and online. You can restore deleted files and folders from your OneDrive recycle bin on the web for up to 30 days for items stored in OneDrive personal (when you're signed in with a Microsoft account), or for up to 93 days for items stored in OneDrive for work or school or SharePoint in ...