Excel – If cell is not blank (Formula & VBA)
In this article we will see how we can identify, and operate in different ways, blank cells directly in formulas and VBA code. Read More …
Tag: cell
Excel – Conditional Formatting based on another Cell
When you want to format a cell based on the value of a different cell, for example to format a Read More …
Create Barcode without Third Party Software (Microsoft Excel)
A barcode is a series of lines with varying width that hold any type of information. Nowadays, barcode has been Read More …
Add/Insert Leading Zeros To Numbers Or Text (Microsoft Excel)
Supposing you need to input some zip codes or phone numbers in cells of Excel, then you will find Microsoft Read More …
Cell Shows ##### (Excel)
Sometimes, when you enter a formula into Excel, the cell simply shows #####, instead of the expected value. Possible Reason Read More …
Copy values-formatting from a range to another (Excel)
In Excel, copy values and formatting only can do as follows: Select the range you want to copy. Click Edit Read More …
Evaluate value between numbers (Excel)
Send Us a Sign! (Contact Us!) Show More Info This article has total words. (Including header) Generic formula =AND(val>MIN(num1,num2),val<max (num1,num2)) Read More …
Negative Number as Positive (Microsoft Excel)
With a simple custom format code, we can display negative numbers as positive…but…why would we want to? So that we Read More …
Excel – Formula to check if cell contains specific string
=ISNUMBER(SEARCH(substring,text)) If you need to check if a cell contains a substring (specific text), you can do so with the Read More …
Delete custom styles in Microsoft Excel with VBA
Often times, especially when sharing files, perhaps emailing files back and forth to/from co-workers, a file can become bloated with Read More …