Shubhi Rastogi has Published 31 Articles

Java program to iterate over arrays using for and foreach loop

Shubhi Rastogi

Shubhi Rastogi

Updated on 21-Nov-2023 17:59:22

336 Views

In the article, the users will learn how to iterate the arrays for each loop and for loop with the examples. Create an array with the data that have any type of the data like numeric or statement form in the array. Let’s announce any string array known as designations, ... Read More

Java program to merge two arrays

Shubhi Rastogi

Shubhi Rastogi

Updated on 21-Nov-2023 17:53:28

274 Views

In the article, the users are going to merge two arrays. The users create any type of two arrays as input like arr1[] and arr2[] with the examples. The users have to create the two types of arrays with multiple elements as the inputs and it presents the result with ... Read More

How to highlight odd or even numbers in excel?

Shubhi Rastogi

Shubhi Rastogi

Updated on 21-Nov-2023 17:41:25

206 Views

In the article, the users are going to highlight even and odd numbers present in Microsoft Excel. There are several features in the Excel sheet including conditional formatting, and format cells that the users have to fill any type of color according to their needs. The users can use the ... Read More

How to highlight rows based on multiple cell values in excel?

Shubhi Rastogi

Shubhi Rastogi

Updated on 21-Nov-2023 17:28:25

157 Views

In the article, the users are going to highlight the rows based on multiple cell values in Microsoft Excel. There are several features in the Excel sheet including conditional formatting, and format cells that the users have to fill any type of color according to their needs. The users can ... Read More

How to highlight the duplicates and overlapping dates in Excel?

Shubhi Rastogi

Shubhi Rastogi

Updated on 21-Nov-2023 17:21:07

95 Views

In the article, the users will understand how to highlight duplicates and overlapping dates in Microsoft Excel. There are several features in the Excel sheet including conditional formatting, and format cells that the users have to fill any type of color according to their needs. The users can use the ... Read More

How to highlight the last duplicate row/cell in Excel?

Shubhi Rastogi

Shubhi Rastogi

Updated on 21-Nov-2023 16:57:12

69 Views

In the article, the users are going to highlight the last duplicate row in Microsoft Excel. There are several features in the Excel sheet including Ku-tools, Filter, and Auto Fill tab that the users have to fill any type of color according to their needs. The users can use the ... Read More

How to remove all but first x characters from cells in Excel?

Shubhi Rastogi

Shubhi Rastogi

Updated on 23-Aug-2023 11:06:23

125 Views

In the article, we may go to remove or delete all but only the first x which means two characters from cells that we have inserted in the cells in Microsoft Excel. The users have to analyze the data to remove or delete the first two characters from the left ... Read More

How to remove (temporarily hide) conditional formatting when printing in Excel?

Shubhi Rastogi

Shubhi Rastogi

Updated on 23-Aug-2023 11:05:39

166 Views

In the article, we may go to remove or hide temporary the conditional formatting once the users will print the data they want to print from random numbers in the worksheet that the users have to analyze the data or random numbers to remove the conditional formatting. The users must ... Read More

How to remove all brackets from string in a range in Excel?

Shubhi Rastogi

Shubhi Rastogi

Updated on 23-Aug-2023 11:03:23

115 Views

In the article, the user will learn how to remove or delete all of the brackets from the string that we have inserted in the cell such as a Word file and an Excel file in Microsoft Excel. Two examples are demonstrated in this article. First example, use the Find ... Read More

How to remove all asterisk characters from cells in Excel?

Shubhi Rastogi

Shubhi Rastogi

Updated on 23-Aug-2023 10:30:37

1K+ Views

In the article, the user will understand how to remove all asterisk characters from cells in Excel. The users have to analyze the data or random names to remove the asterisk symbol from all cells either by using the formula or by using the Ku-tools tab. This method may be ... Read More

Advertisements