Office Solutions

3 Handy Methods to Batch Add a Prefix to Multiple Cells in Excel Worksheet

If you would like to batch add a specific prefix to multiple cells, you can refer to this article. Here we will introduce you 3 easy methods. Each has its own pros and cons. You can choose one as per your needs. At times, you may need to add a specific text to the beginning of multiple cells in an Excel worksheet. For those Excel newbies, they may tend to add the prefix to each cell one by one. However, it will be extremely time-consuming if there are a great number of cells to be processed....

Read more »

How to Quickly Extract the Email Addresses from the Tables in Your Outlook Email

If you need to extract all email addresses appearing in all tables of an email, you can use the method shown in this article. It can let you get it in a jiffy. You receive an email, which contains a lot of email addresses in its message body. Some of the email addresses are in the tables, but some are in the textual body. At times, you may only want to extract the email addresses from the tables. Usually, in standard means, you have to manually copy to extract the email addresses. But, it...

Read more »

2 Fast Means to Split an Excel Worksheet’s Contents into Multiple Workbooks Based on a Specific Column

At times, in data analysis, you may need to split the contents of an Excel worksheet into multiple Excel workbooks according to a specific column. Now, in this post, we will teach you 2 quick ways to get it. Many users frequently need to split an Excel worksheet that contains huge rows of data into multiple separate Excel workbooks based on a specific column. For instance, here is my sample Excel worksheet. I would like to split this sheet's data on basis of the "Price of single license...

Read more »