Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
MS Excel Articles
Page 81 of 119
How to Convert Text String to Proper Case with Exceptions in Excel?
Have you ever wondered if there is a way in Excel to automatically correct the case of strings in a sentence? It is possible to make it happen in Excel. This tutorial will help you understand how you can convert text strings to proper cases with exceptions in Excel. We can complete this task using the VBA application, as it can’t be completed directly in Excel. When the letters of the words are in the correct case according to grammar, they are called "proper case." Converting Text String to Proper Case with Exceptions in Excel Here, we will first create ...
Read MoreHow to Convert Text in Text Box to Cell Content in Excel?
When we have data in text boxes in Excel and need to manually extract the data from the box, it can be a time-consuming process. We can’t perform any operations on the dates if they are in a text box, as they are treated as comments. Read this tutorial to learn how you can convert text in a textbox to cell content in Excel. We can complete the process using the VBA application, as it can't be completed directly in Excel. Converting Text in Text Box to Cell Content in Excel Here we will first insert the VBA module then ...
Read MoreHow to Convert Text Datetime Format to Real Datetime Format in Excel?
Sometimes in Excel, you can see that the date and time are given in the form of strings, and you will not be able to perform operations related to data and time with those values. So, it is very important for us to convert these kinds of formats into the correct format. If we try to do this manually, it can be time-consuming and sometimes inaccurate. We can complete this task using the formulas to get more accurate results and save a lot of time. Read this tutorial to learn how you can convert text date and time formats to ...
Read MoreHow to Convert Temperature Units between Celsius, Kelvin and Fahrenheit in Excel?
The degree of hotness or coldness of any object is known as its temperature. Generally, temperature can be measured on these scales: Celsius, Kelvin, and Fahrenheit. Different people will measure temperature on different scales. So, changing the scale of temperature can be used frequently when dealing with temperatures. Read this tutorial to learn how you can convert temperature units between Celsius, Kelvin, and Fahrenheit in Excel, i.e., changing the values from Celsius to kelvin or Fahrenheit and vice versa. We can solve this process by using formulas supported by Excel. Converting Temperature Units between Celsius, Kelvin and Fahrenheit in Excel ...
Read MoreHow to Convert Seconds to Time (hh mm ss) or Vice Versa in Excel?
The data in the sheet can be very confusing if it is presented in seconds, and the value will be so large that you won't be able to perform any operations on it. A second typically corresponds to 1/3600 of an hour. We can use this method to determine the duration in seconds. You can learn how to convert seconds to time in Excel from the information provided in this tutorial. In this tutorial, we'll try to use the formulas to convert seconds to duration. Although a direct formula is not yet available, we can create one by simply comprehending ...
Read MoreHow to Convert Scientific Notation to Text or Number in Excel?
Generally, a scientific notation will have more than 12 values in it, and if we try to enter any value that has more than 11 digits, it will automatically convert into a short form. We can solve this problem by following some simple tricks. Read this tutorial to learn how you can convert scientific notation to text or a number in Excel. This problem can be solved in three ways: first, with a single quote; second, with formatting; and third, with the trim function. Converting Scientific Notation to Text Using Single Quote Here we will insert a single quote before ...
Read MoreHow to Convert a Range to a Table or Vice Versa in Excel?
There are many special features in Excel that are only available in tables and can't be applied to normal ranges of data. Operations like sorting and inserting are some of the simplest processes in case of tables. Sometimes, we need to convert a range of data to a table to access those features. Read this tutorial to learn how you can convert a range of data to a table and a table to a range of data in Excel. It is a very simple process. A table will also help us understand our data in a more precise and faster ...
Read MoreHow to Convert a PivotTable to a List in Excel?
A pivot table is a table of grouped values that aggregates the individual items of a more extensive table with multiple distinct categories. The operations that we can perform include sum, max, min, average, and many other mathematical operations. Have you ever tried to convert a pivot table to a list in Excel? If you try to solve this problem manually, it can be a time-consuming and complex process. Read this tutorial to learn a simple trick that you can use to convert a Pivot table to a list in a faster and more accurate way. Converting a PivotTable to ...
Read MoreHow to Convert One Cell to Multiple Cells/Rows in Excel?
Have you faced a problem where all the data is present in a single cell and you are unable to perform any operations and need to divide the data into multiple cells? If you try to divide the data manually, then it can be a time-consuming process. Instead, you can use a simple trick mentioned in this tutorial to save time and get more accurate results. Read this tutorial to learn how you can convert one cell to multiple cells or rows in Excel. Converting One Cell to Multiple Cells/Rows in Excel Here, we will first use the Text to ...
Read MoreHow to Convert Numbers to Year/Month/Day or Date in Excel?
Have you ever tried to convert the number of days to years, months, and days in Excel? If we try to do this by hand, it can be a time-consuming process because we need to divide to get the year, age it to get the months, and then repeat the process to get the days. We can solve this process in a more straightforward and time-efficient manner. Read this tutorial to learn how you can convert numbers to years, months, and days in Excel. Converting Numbers to Year/Month/Day in Excel Here we will use the DATEDIF formula to get any ...
Read More