Excel Lookup Function lookup multiple criteria

Posted on February 21, 2015September 16, 2017 by Wyman W

This Excel tutorial explains how to use Excel Lookup Function and how to look up multiple criteria. You may also want to read: Excel Vlookup second matched value or specific occurence Excel Lookup Function lookup multiple criteria not in the first column Excel lookup partial text using Vlookup with Wildcard Excel Lookup Function - lookup multiple criteria Excel Lookup Function is to look up a value in a Range (or array) and return the corresponding result in another Range (or arra...

Excel Char Function to convert ASCII value to character

Posted on February 9, 2015February 9, 2015 by Wyman W

What is Excel Char Function? Excel Char Function converts ASCII value to a character. ASCII (American Standard Code for Information Interchange) uses 8-bit code units, an old encoding system which stores mainly numbers, lowercase letters a to z, uppercase letters A to Z, basic punctuation symbols, control codes. Many old systems still use this encoding system. 8 bit means the computer memory uses “8” digits with 1 and 0 combination (binary) to represent a character, 8 bits memory is equal to ...

Excel Code Function to get ASCII value of text

Posted on February 7, 2015October 24, 2017 by Wyman W

What is Excel Code Function? Excel Code Function returns the ASCII value of the first character in a text. ASCII (American Standard Code for Information Interchange) uses 8-bit code units, an old encoding system which stores mainly numbers, lowercase letters a to z, uppercase letters A to Z, basic punctuation symbols, control codes. Many old systems still use this encoding system. 8 bit means the computer memory uses “8” digits with 1 and 0 combination (binary) to represent a character, 8 bits ...

Excel LEN Function to measure length of text

Posted on February 6, 2015 by Wyman W

What does Excel LEN Function do? Excel LEN Function is to measure length of a text. Why do you need Excel LEN Function? Excel LEN Function is not quite meaningful to use alone, it is more of a stepping stone to achieve another purpose. LEN Function is most commonly used with the following functions in order to extract a substring from a string. LEFT Function - extract a substring on the left RIGHT Function - extract a substring on the right MID Function - extract a substring in the m...

Excel MID Function to extract substring

Posted on February 4, 2015December 25, 2016 by Wyman W

This Excel tutorial explains how to use Excel MID Function to extract substring from a string, and use with FIND and SEARCH and LEN Function. You may also want to read: Extract text in brackets Remove text in brackets Excel MID Function MID Function is quite similar to LEFT Function and RIGHT Function, where RIGHT Function extracts a substring on the right, LEFT Function extracts a substring on the left, while MID extracts a substring in the middle of the string. MID Function is co...

Excel DateValue Function to convert text to Date

Posted on January 28, 2015February 27, 2015 by Wyman W

What does Excel DateValue Function do? Excel DateValue function is used to convert a text to Date Serial, a numeric value that represents the Date. Why do you need Excel DateValue Function? Date is being treated specially in Excel. The format you see in Excel worksheet such as dd/mm/yyyy is only a displayed formatting, the underlying value of a Date is a numeric value. 1/1/1900 is considered as the first date in Excel, the numeric value of it is 1, and add one to each day onwards. Everytim...

Excel Date Function

Posted on January 27, 2015March 14, 2016 by Wyman W

This Excel tutorial explains how to use Excel Date Function. You may also want to read: Excel first date of month and last date of month Excel Date Function Excel Date function is used to transform year, month, day into Date Serial, a numeric value that represents the Date. Why do you need Excel Date Function? Date is being treated specially in Excel. The format you see in Excel worksheet such as dd/mm/yyyy is only a displayed formatting, the underlying value of a Date is a numeric v...

Excel Find Function

Posted on January 21, 2015December 25, 2016 by Wyman W

This Excel tutorial explains how to use Excel FIND Function for Excel worksheet, and also explains the differences between INSTR and SEARCH function. You may also want to read: Extract text in brackets Remove text in brackets Excel Find Function Excel Find function is used to search a substring (part of the string) within a string and return the position of the first occurrence, note that Excel Find function is case sensitive. Excel Search function is very similar to Find functi...

Excel Search Function

Posted on January 21, 2015September 1, 2016 by Wyman W

This Excel tutorial explains the Excel Search Function for Excel worksheet, and also explains the differences between INSTR and FIND function. Excel Search Function Excel Search function allows Wildcard to search a substring (part of the string) within a string and return the position of the first occurrence. Excel Search Function is not case sensitive, you should consider using Excel FIND Function for case sensitive comparison, but FIND Function cannot use Wildcard. For example, ...

Excel RAND RANDBETWEEN Function to generate random number

Posted on January 12, 2015March 27, 2015 by Wyman W

This Excel tutorial explains how to use Excel RANDBETWEEN Function and Excel RAND Function to generate random number and explain the difference. Excel RAND RANDBETWEEN Function - generate random number Before Excel 2007, Excel uses RAND Function to generate a random number that is greater than zero and smaller than 1. Since Excel 2007, a new Function RANDBETWEEN was added, it is used to generate a random integer between two desired integers. Note that RANDBETWEEN and RAND Functions are...