Function should give output in “General” format, however if output is not as per the desired format then we need to change the cell format to “GENERAL”.
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:-
SMALL function is used to get the Smallest k-th value from the range.
SMALL Function has two required arguments i.e. array, and k
RAND AND RANDBETWEEN FUNCTION We have got many instances where we needed to generate a random database or values. “RAND function” is very useful for users who creates random database for various types of working…
Excel Function REPLACE REPLACE function is used to replace the existing text from a specific location in a cell to New Text. REPLACE Function has argument four arguments i.e. old_text, start_num, num_chars and new_text. We need to give the…
Generate Random Numbers in Excel Using RAND We have got many instances where we needed to generate a random database or values. Rand function is very useful for the users who creates random database for…
COLUMNS function is used to get the total count of columns in an array or in cells range for excel worksheet.
INDIRECT function is used to convert the text/string into cell reference. Function provides output as the value of that cell reference.