Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Google sheets is a web based application that acts like a Software as a service in offering similar fundamental functionality to excel. With this functionality, we can accomplish many common spreadsheet tasks, and in this tutorial we will look into various ways of extracting just the numbers from text strings in google sheets. Using the REGEXEXTRACT Function Here we look at the simple case where the numbers are all sequential in one substring of the text given. Step 1 − Open google sheets and input all your texts into the respective cells. Step 2 − Use the REGEXEXTRACT function with the ... Read More
Excel is a powerful tool that can help you organize and manage your tasks, events, and appointments. One of the most useful features of Excel is the ability to create dynamic calendars that update automatically as you make changes to your schedule. A dynamic monthly calendar can help you stay on top of your schedule and ensure that you never miss an important appointment or event. With Excel's powerful tools and features, you can easily create a calendar that suits your needs, whether you need to track your personal schedule, manage a team's schedule, or keep track of deadlines and ... Read More
Excel is a powerful tool for managing and analyzing data, but one common issue users face is dealing with lists that contain empty cells. This can be especially frustrating when you're working with large datasets or trying to create charts and graphs. Fortunately, there is a simple solution: creating a dynamic list that automatically adjusts to exclude blank cells. In this tutorial, we'll walk you through the steps for creating a dynamic list that eliminates blanks, allowing you to more easily work with and analyze your data. We'll cover everything from setting up your data range and creating a named ... Read More
Excel is a powerful tool that allows you to organize and analyze data in a structured manner. One of the most common tasks that users perform in Excel is managing multiple worksheets within a workbook. As the number of worksheets in a workbook increases, it can become increasingly difficult to keep track of them all. In order to streamline your workflow and make your Excel experience more efficient, you can create a dynamic list of worksheet names that can be easily updated and referenced. This tutorial will guide you through the process of creating a dynamic list of worksheet names ... Read More
Excel is a powerful tool that allows users to create visually appealing charts to represent data. However, the title of the chart is just as important as the data itself. A dynamic chart title in Excel can make a huge difference in the way your chart is perceived and can convey more information than a static title. In this tutorial, we will guide you step-by-step on how to create a dynamic chart title in Excel. Here, we can use the Name box to complete the task. So let us see a simple process to know how you can create ... Read More
In this tutorial, we will be going over how to extract initials from cells in Microsoft Excel. This will involve use of combined functions in excel, and since there are slightly different ways to do this we will be going over both. Using Left, Find, and Mid Functions Together with & To understand this method we should go over how the 3 key functions work − The left function in excel will return the first characters (or characters if an amount is specified) of a cell. The find function will give the position index of a specified character ... Read More
Since Natural language can be open to multiple interpretations at times, this would pass on to the computers who will try to understand the natural language input given to them. Often, it can be difficult to fully understand a sentence when we are not given enough context or if there is poor grammar. In this article we will be going over many different types of ambiguities that are found in NLP. Part Of Speech (POS) Tagging Ambiguity POS tagging refers to the process of classifying words in a text to a part of speech - whether the word is ... Read More
Excel is a powerful tool that offers numerous functions to manipulate and extract data. Extracting the first letter of each word from a cell can be particularly useful when you need to analyse or categorize text data. In this article, we will explore a step−by−step guide on how to extract the first letter of each word from a cell in Excel. Step 1 Open Excel and Enter Data Start by opening Microsoft Excel and entering your desired text into a cell. For the purpose of this tutorial, let's assume our text is in Cell A2. Step 2 Hold down the ALT ... Read More
In today's digital age, where we handle a plethora of files and data, it is essential to efficiently organize and manage our information. One common task is extracting file extensions from a worksheet, which can be helpful for various purposes, such as categorizing or analysing data. In this article, we will guide you through the process of extracting file extensions from a worksheet using different software applications and programming languages. Let's get started! To extract file extensions from cells, you can use the following formula − Method 1: Extract file extension from worksheet with formula Step 1 In an ... Read More
Duplicating rows can be a useful technique when you need to expand or replicate data in your spreadsheet. By following the steps outlined in this tutorial, you'll be able to quickly duplicate rows based on specific criteria, making it easier to manipulate and analyse your data. Whether you're working with large datasets, performing data analysis, or simply organizing information, Excel provides powerful tools that can save you time and effort. Duplicating rows based on a cell value is one such technique that can help you efficiently expand your data. Duplicate Rows Based On Cell Value Here, we will first ... Read More