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 …

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 …