Excel Tricks with Tejraj

In this blogpost, we will learn to merge data from duplicate rows into a single cell in excel. Many times, we may face a situation where we have duplicate entries in rows,  and we want to merge the data from these duplicate entries into single cell. This post is perfect solution for similar problems. Let us understand this solution with simple example. Let us assume that we have a supplier database in which we have multiple contacts listed for same supplier in multiple rows (as shown in below image). In this database, Supplier 1 with unique supplier code has 03 different Contact IDs listed in 03 different rows and same scenario is with Supplier 2, Supplier 3, Supplier 4 and Supplier 5. Now we want to merge these multiple Contacts IDs for respective supplier in a single cell separated by semicolon (;). To merge data from multiple rows into a single cell in excel, follow below simple steps: Before following the below steps make sure “Supplier Code” column is sorted (Sort Type is...

In our previous blog post, we have seen how to insert Today’s date in excel. In this blog post we will learn to insert today’s date along with current time in excel. To display today’s date along with current time we can use NOW function which is readily available in excel. Where to find NOW function on Excel Screen: NOW function can be found under “Date & Time Function” category under “Formulas” tab and under “Function Library” group as shown in below image: Once we click on “Date & Time” category, we can see list of various Date & Time Functions available in excel. NOW function is highlighted in blue in below image. Once we click on NOW option as highlighted above, we will get the function argument dialog box as shown in below image: Syntax of NOW Function: The Syntax of NOW function is as below: =NOW() Arguments of NOW Function: NOW function does not take any argument. Once we click on the “OK” button on dialog box which appears once we click NOW function as explained ab...

In this blog post we will learn about TODAY function in excel. Whenever we want to display today’s date in excel, we can use TODAY function. Where to find TODAY function on Excel Screen: TODAY function can be found under “Date & Time Function” category under “Formulas” tab and under “Function Library” group as shown in below image: Once we click on “Date & Time” category, we can see list of various Date & Time Functions available in excel. TODAY function is highlighted in blue in below image. Once we click on TODAY option as highlighted above, we will get the function argument dialog box as shown in below image: Syntax of TODAY Function: The Syntax of TODAY function is as below: =TODAY() Arguments of TODAY Function: This function does not take any argument. Once we click on the “OK” button on dialog box which appears once we click TODAY function as explained above, today’s date will immediately appear in selected cell. Another way to insert today’s date: Instead of entering...

In this blog post we will learn about SECOND function in excel. SECOND function returns SECOND portion from the selected TIME. The output of SECOND function will be from 0 to 59. Where to find SECOND function on Excel Screen: SECOND function can be found under “Date & Time Function” category under “Formulas” tab and under “Function Library” group as shown in below image: Once we click on “Date & Time” category, we can see list of various Date & Time Functions available in excel. SECOND function is highlighted in blue in below image. Once we click on SECOND option as highlighted above, we will get the function argument dialog box as shown in below image: Syntax of SECOND Function: The Syntax of SECOND function is as below: =SECOND(serial_number) Arguments of SECOND Function: To use the SECOND function, we have to provide only one argument: Serial_number : In this argument we have to enter a time from which we want to identify SECOND. Example of SECOND Function: Let’s learn a...