Freelance Project Requests info@CodeDocu.de Software Development in C# WPF Asp.Net Core Vba Excel Word SQL-Server EF Linq, UWP Net
#
Excel : Convert numbers to text Office-365/Excel/Formulas
Excel : Convert numbers to text
10.01.2020 789
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

Excel function: find the position in a column or row Office-365/Excel/Formulas
Excel function: find the position in a column or row
26.11.2019 655
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

Excel: Find text in a value Office-365/Excel/Formulas
Excel: Find text in a value
07.11.2019 689
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)

Excel: Count how often a value occurs Office-365/Excel/Formulas
Excel: Count how often a value occurs
07.11.2019 672
With the formula = COUNTIF (B:B;" =" & B6)

Excel Exponent Numbers Office-365/Excel/Formulas
Excel Exponent Numbers
22.10.2018 1151
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

Excel: Text Like function Office-365/Excel/Formulas
Excel: Text Like function
08.01.2018 1561
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

Excel: Determine a substring from text with Formulas Office-365/Excel/Formulas
Excel: Determine a substring from text with Formulas
08.01.2018 1538
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

Excel: Barcode by Excel Insert macro code into cells Office-365/Excel/Formulas
Excel: Barcode by Excel Insert macro code into cells
20.10.2017 5736
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

Excel Macro Formulas for calculation Office-365/Excel/Formulas
Excel Macro Formulas for calculation
20.10.2017 1695
Example how to calculate complex formulas in Microsoft Excel Tutorial

Excel: Enter values ​​from your own function formula Office-365/Excel/Formulas
Excel: Enter values ​​from your own function formula
20.10.2017 1878
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

Mobile

.

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