Category: Microsoft Excel

There are several different ways to copy the full path of a folder or files. Please see below for details: To Copy the Full Path of a Folder: Step …

When working with Excel file, you can save an Excel file as a PDF file, however, this is to save one Excel file into PDF. When you need to …

When working with Excel, you may want to separate the worksheet into different several tabs (or worksheets). There are different methods to separate them. For example, If you have …

I worked on a spread sheet received from another person and found there are some spaces or tabs in some cells. At the very beginning, I thought they are …

When working with Pivot Table, you may need to add extra calculated fields to make your Pivot Table better. For example, to add the percentage calculation between 2 columns, …

To extract the text before the at sign (@), you need to find the location of the special character of the at sign (@) and then use the Left …