tutorial

Extract text before or after a character in Excel

In this article, I’ll present how you can extract or remove the text before and after a character. In the later part, there…

To convert a standard date to month and year, you can use the TEXT function. This function converts a value to text in…

With the COUNTIF function, you can count the number of cells that meet a single condition. The following example contains a list of…

You can perform similar operations on dates and numbers because dates in Excel are nothing more than numbers in a date format. You…

When you work with Excel, you can switch between sheets by just clicking them. But when you have many of them, that you…

When you are working with data inside Excel worksheet, sometimes you need to delete the particular type of data. If you have a…

There are a few ways you can remove characters from cells in Excel. You can do it from the ribbon, using the formula,…

Deleting a value inside a cell is easy, just click a cell and press delete. But how you can delete a cell that…

When you deal with several cells inside your spreadsheet data, adding commas manually in particular places inside cells may be a good decision,…

In Excel, you can save a file using the VBA code. You can do it by specifying the path and name of a…