Tag: excel
Excel: When a cell contains a character
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,...
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...
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...