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 a new cell.
CONCATENATE Function has argument called “text”, where we need to give the cell references, we can give multiple cell references as per the requirement to combine by following the “ , “ (i.e. Comma) as separator.
Formula =CONCATENATE(
The CONCATENATE function allows you to combine text from different cells into one cell. In our example, we can use it to combine the text in column A and column B to create a combined name in a new column. Before we start writing the function, we’ll need to insert a new column in our spreadsheet for this data. Lets learn with few examples given below:-
As we can see in the below images by applying simple CONCATENATING Formula two cell values are easily combined into one.
Formula =CONCATENATE(A2,” “,B2)
The Excel CONCATENATE function is not only combined cell values. we can use the function to join a cell value and a string as well. For example:-
LEFT function is used for extracting the “Left Most” characters from the available string. The output of the function returns the extracted characters in new cell
AND, OR, NOT Functions” provide result in “TRUE” or “FALSE”. If the logical condition is correct and matching the parameters provided, then result would be “TRUE” or if logical condition is not correct and not matching the parameters provided then result would be “FALSE”
MAX function is used to get the largest number in range or list of values. MAX function has one required argument i.e. number1
MOD function is used to get the remainder of number that is divided by divisor. MOD Function has two required arguments i.e. number and divisor.
https://youtu.be/HmJL_y93pAs WEEKNUM function helps to calculate the week number of the given date in a year. It considers 1st January as first week by default and through the output for the given input date. Syntax:…
This guide shows how to use the nested IF function in Excel to check several conditions. You will also learn about other functions that can be to use than a nested formula.
When you want to make decisions in Excel, you often use an IF formula. It checks if something is true, then gives one result if it is and another result if it isn’t. If you need to check more than one thing, you can put many IFs inside each other.
Although using multiple IFs is common, it’s not the only way to check several conditions in Excel. This guide will introduce you to some easier and useful alternatives.