Excel
Excel: When a cell contains a character
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
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
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
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
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
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)
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
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
Add guest user To enable cooperative collaboration, external users need a guest user in their own M365 tenant. To do...
Skip to content