Excel

Excel: When a cell contains a character 0168

OVERVIEW To check whether a cell contains a specific text or number, we need the following functions SEARCH, ISNUMBER and...

Remove line breaks from Excel 0168

Example: Line breaks have been created in individual cells of an Excel spreadsheet. If you want to delete them again,...

Concatenate Sreference with multiple results 043

If you want to use an Sverweis but need multiple results, Power Query will help you! Proceed as follows: 1....

Change maximum characters per row in Excel 045

If you want to limit the number of characters per row in Excel, proceed as follows. Select the line you...

Sumwenns with TODAY() as condition 042

If you want to form a sum with values where the due date has passed, this notation from Summewenns can...

Excel | Read up to one character 045

Welcome to Olbricht IT, your expert for everything to do with Excel and Microsoft 365! Today we’re delving into the...

Change Microsoft account in Office applications (Word, Excel, PowerPoint) 045

If the upload of data fails in Office applications, you should check/change the associated Microsoft account. This is how you...

0 ahead for a number in Excel 047

This small formula helps you to introduce a 0 for single-digit numbers in Excel: =TEXT(TAG(A1); “00”) Column A1 contains a...

External collaboration with the Excel app 1209

Add guest user To enable cooperative collaboration, external users need a guest user in their own M365 tenant. To do...
Skip to content