Similar Posts

EXCEL FUNCTION – CONCATENATE
CONCATENATE function is used for combining two or more Microsoft Excel strings into one. The output of the function returns as a combined string in new cell.

EXCEL FUNCTION – DATEVALUE
The Article of DATEVALUE explains how to use Excel functions to change text into dates and numbers into dates. It also shows how to convert text strings into dates without using formulas. You’ll also learn…

EXCEL FUNCTION – LEN
LEN function is used for counting number of characters in available string. The output of the function returns the count in new cell.

EXCEL FUNCTION – COUNTIFS
COUNTIFS function is used to get the total count for number of times the various criteria across ranges are met.

EXCEL FUNCTION – RIGHT
RIGHT function is used for extracting the “Right Most” characters from the available string in Microsoft excel. Function returns value to new string.

EXCEL FUNCTION – TRIM
TRIM function is used to remove the additional spaces (i.e. spaces before/after/between the words) except for single space between words.

EXCEL FUNCTION – CONCATENATE
CONCATENATE function is used for combining two or more Microsoft Excel strings into one. The output of the function returns as a combined string in new cell.

EXCEL FUNCTION – DATEVALUE
The Article of DATEVALUE explains how to use Excel functions to change text into dates and numbers into dates. It also shows how to convert text strings into dates without using formulas. You’ll also learn…

EXCEL FUNCTION – LEN
LEN function is used for counting number of characters in available string. The output of the function returns the count in new cell.

EXCEL FUNCTION – COUNTIFS
COUNTIFS function is used to get the total count for number of times the various criteria across ranges are met.

EXCEL FUNCTION – RIGHT
RIGHT function is used for extracting the “Right Most” characters from the available string in Microsoft excel. Function returns value to new string.

EXCEL FUNCTION – TRIM
TRIM function is used to remove the additional spaces (i.e. spaces before/after/between the words) except for single space between words.

EXCEL FUNCTION – CONCATENATE
CONCATENATE function is used for combining two or more Microsoft Excel strings into one. The output of the function returns as a combined string in new cell.

EXCEL FUNCTION – DATEVALUE
The Article of DATEVALUE explains how to use Excel functions to change text into dates and numbers into dates. It also shows how to convert text strings into dates without using formulas. You’ll also learn…

EXCEL FUNCTION – LEN
LEN function is used for counting number of characters in available string. The output of the function returns the count in new cell.

EXCEL FUNCTION – COUNTIFS
COUNTIFS function is used to get the total count for number of times the various criteria across ranges are met.

EXCEL FUNCTION – RIGHT
RIGHT function is used for extracting the “Right Most” characters from the available string in Microsoft excel. Function returns value to new string.

EXCEL FUNCTION – TRIM
TRIM function is used to remove the additional spaces (i.e. spaces before/after/between the words) except for single space between words.