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...
Excel
-
-
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... -
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... -
How to display barcodes in Excel
In this article, you will learn how to display barcodes for your data in Microsoft Excel. This method only works... -
How to convert column names such as “AX” into a column number (without VBA)
You have a column designation such as “AX” in Excel and want to know how many columns this is –... -
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...
