IFERROR

Explanation IFERROR Excel function returns a custom error message in case of an Excel error. An Excel error can be one of the following: #N/A - Value not found #DIV/0…

0 Comments

EOMONTH

Explanation EOMONTH allows us to return the date of the last day of a month, based on a specific date provided. For example, we can use EOMONTH to find out…

0 Comments

WEEKDAY

Explanation WEEKDAY function returns the number of the day in the week - from 1 to 7. WEEKDAY Syntax =WEEKDAY(serial_number, [return_type]) serial_number - The date for which we want to…

0 Comments

DATE

Explanation DATE function allows us to create a date from individual numbers which represent the day, month and year. Syntax =DATE(year,month,day) year - The value of the year  month -…

0 Comments

DAY, MONTH, YEAR

Explanation DAY, MONTH, YEAR are used for extraction of the day, month and year part from an Excel date. Let's see how it works! Syntax To extract the day from…

0 Comments

LOWER, UPPER, PROPER

Explanation LOWER, UPPER and PROPER are text functions which let us do the following: LOWER - Converts all words in the text to lowercase. UPPER - Converts all words in…

0 Comments

TRIM

Explanation TRIM function is used for the removal of extra space characters.  When the excess spaces appear between two words, the function keeps only one space character. Example Notice the…

0 Comments

SEARCH

Explanation SEARCH function lets us find the position of a text within another text/cell.  Note that FIND is case-insensitive. You can use it to lookup lowercase/uppercase letters - all combinations…

0 Comments

FIND

Explanation FIND function lets us find the position of a text within another text/cell.  Note that FIND is case-sensitive, meaning that if you try to find "GOAT" within "goat cheese",…

0 Comments

LEN

Explanation LEN function is used to discover the LENGTH of a cell - It allows us to know the number of characters in a certain cell. Let's see how it…

0 Comments

End of content

No more pages to load