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 IF. If we want to be case sensitive, we use…
-
-
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, you have to remove them all manually. Solution : the line…
-
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. grouping All rows (result: Table Object) 2. convert table object…
-
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 want to limit Select the Data tab at the top…
-
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 help: In this example, the remaining amount that is already…
-
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 world of Excel functions and showing you how you 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 can change your account: Switch to the “Account” item on…
-
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 date as an example.
-
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 – i.e. column 50? Then you don’t need a complicated formula…
-
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 this, go to the Admin Center and select Users >…
Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help!
