An email address of a person, in most cases, is generally a combination of the first and last name, ending with the host details such as @gmail.com, @yahoo.com, etc. Suppose we have an Excel sheet with two columns containing the first and last names of employees, then we can easily append their email addresses in a third column, by combining the data values of the first two columns. Adding Email Address to a List of Names We can follow a simple process to add email addresses to a list of names. Basically, this process contains two parts, the first step ... Read More

Let's suppose you need to add a particular text string in all the cells of an Excel sheet at the beginning or end of the existing data. It can be a tedious process if you decide to perform this such a task manually. In this tutorial, we will show you a simple method by which you can do it using a formula in Excel. We can add text in beginning or end using the same formula but the process is sequence of the work is different. Let us see the simple process to add text in bigging or end of ... Read More

Suppose you have an Excel sheet with a column of data and you need to add a string of text at a specific position in all the column data. In such cases, you don't have to type the entire data all over again to update the given column data. In this tutorial, we will demonstrate in a few simple steps how you can add the new data in between an existing set of data. Add Text in the Middle of Selected Cells in Excel Suppose we have an Excel sheet with a list of data that starts with the letter ... Read More

When we have two separate columns in an Excel sheet which are to be combined, you don't have to create a new column and enter the whole data again. In this tutorial, we will show you two different ways to combine text cells together into one cell. You can either used the Ampersand symbol (&) or the CONCAT function for this purpose. We will take a simple example to demonstrate how it is done. We will take to columns that would contain the "first name" and "last name" of a set of people. Then, we will create a new column ... Read More

Sometime we may want to place a textbox above each bar of a bar graph to provide additional information. Such textboxes help the users understand the graph quickly and analyse the data in a better way. Most of the time, we use such textboxes to highlight the highest and lowest points in a graph, for example, highest and lowest sales numbers. Read through this tutorial to find out how you can follow a simple process to add a textbox above each bar of a bar graph. Adding Text Box To a Chart In Excel Here we will first create a ... Read More

Let us assume a situation where we want to calculate the tax you need to pay on your total income. This problem has two steps first we calculate your total income by adding income from all your sources of income and the second step is to multiply it with the percentage of the tax you want to pay. We can solve this whole problem in a single calculation with the help of below information. here first we add the two numbers and multiply using one formula. Adding Two Numbers in Excel and Then Multiplying in One Formula Let us see ... Read More

Applying subscript and superscript are not default functions in Excel, however you can customize the Excel ribbon or the quick access toolbar to show these functions. In this article, we will take a simple example to demonstrate how you can customize the Excel ribbon. Adding Subscript and Superscript Functions to the Excel Ribbon The Excel ribbon is the place that includes some of the frequently used functions such as Conditional Formatting, Cell Styles, Autosum, etc. Step 1 To display the subscript and superscript functions on this ribbon, right-click on the ribbon and select "Customize the Ribbon", as shown in the ... Read More

When you collect data from another source and use that in an Excel sheet, it may not look good. The space provided between numbers in an Excel cell is very less and it will not be very clear. There is a need for increasing the space between the numbers in the cell to represent the numbers neatly. You can use Formulas in Excel to add more space between numbers. In this tutorial, we will take an example to show how you can use a simple formula to add space between numbers in cells and make them more presentable. Adding Spaces ... Read More

We use commas to separate items of the same category in a list. If the words are not separated clearly by commas and spaces, then it looks ugly and impossible to understand. You might have come across situations where you borrowed some data from the Internet and used it in an Excel sheet, only to realize that the data missing spaces and commas. You can, of course, insert commas manually, but it will be a time-consuming affair. In this tutorial, we will show you a simple way to insert spaces after commas in an Excel sheet. Adding Spaces after Commas ... Read More

A series line in Excel helps us to connect the data objects of same time period. A series line helps us to analyse the charts more efficiently without any confusion. A series line connects the data objects of same rows with a line. Generally, series lines are added to the stacked or 100 stacked columns. In this tutorial, we will demonstrate how you can add series lines in a chart in Excel. Adding Series Line in an Excel Chart Let us suppose we have an Excel sheet with the following data: Step 1 To create the chart, select the ... Read More