Freelance Project Requests info@CodeDocu.de Software Development in C# WPF Asp.Net Core Vba Excel Word SQL-Server EF Linq, UWP Net
 # Office-365/Excel/Formulas Excel : Convert numbers to text 10.01.2020 1562 The following example shows how to convert numbers to text in Microsoft Excel The problem is that SAP used to output numbers such as personnel numbers or accounts in Excel as text You could see it by the fact that the numbers were displayed left-aligned in Excel Since Office-365/Excel/Formulas Excel function: find the position in a column or row 26.11.2019 1180 Actually, the function comparison (search text; search area,1) But the formula always leads to a problem in vba Excel That's why I simply rewrote the function here with =get_First_Match(SearchText; search area) The function, the code is below for copy Office-365/Excel/Formulas Excel: Find text in a value 07.11.2019 1187 Excel: Find text in a value the formula finds the text position in which a text or character occurs The difference is =SEARCH and =FIND in whether case is case sensitive =SEARCH("a"; B4) Office-365/Excel/Formulas Excel: Count how often a value occurs 07.11.2019 1155 With the formula = COUNTIF (B:B;" =" & B6) Office-365/Excel/Formulas Excel Exponent Numbers 22.10.2018 1863 High number in Excel Hochzahl is the character ^ The key for ^ is located to the left of the 1 and is simply clicked and then a space Example: 2 4 Giga heart is the frequency for mobile phones = 2 4 * 10 high 9 Office-365/Excel/Formulas Excel: Text Like function 08.01.2018 2181 Task: A formula that allows you to check a text for the occurrence of a search text or term In vba this is the formula LIKE Solution: Formula = ISNUMBER (FIND ("balance"; B3)) In the display in E Office-365/Excel/Formulas Excel: Determine a substring from text with Formulas 08.01.2018 2137 Excel: Determine substring from text If you want to determine a certain text from a cell from long Excel lists, then you use several formulas The best way to create the result of several steps If you want to calculate the number a Office-365/Excel/Formulas Excel: Barcode by Excel Insert macro code into cells 20.10.2017 9542 This example contains an Excel file with a macro code, which can be used to supplement any existing Excel document with an additional barcode of type 39 The barcode is generated purely by a vba code in the background, whereby always a small barcode is drawn into Office-365/Excel/Formulas Excel Macro Formulas for calculation 20.10.2017 2620 Example how to calculate complex formulas in Microsoft Excel Tutorial Office-365/Excel/Formulas Excel: Enter values ​​from your own function formula 20.10.2017 2659 In MS Excel, you can write your own functions and computations in the vba macro code, and output them in the Excel sheet by means of a formula

.

Contact for Jobs, Project Requests: raimund.popp@microsoft-programmierer.de