Office Solutions

2 Methods to Sort a Column with both Numbers and Texts in Your Excel

Sometimes in a column, the cells will contains both numbers and texts. Here we will provide two methods to sort a column with numbers and texts. Sometimes there will be numbers and texts in the same cells in a column. If you need to sort this column, you will meet with problems. The order of the column will not be “1,2,3,4,5..”, but it will be “1,10,11,12,…2,21,22…”. Therefore, this kind of order will make your worksheet in a mess. In order to solve such a problem and sort the...

Read more »

How to Auto Assign a Task to a Specific Person at a Scheduled Time with Outlook VBA

Many users desire that Outlook can automatically assign a specific task to specific people at a scheduled time, like the “Delay Delivery” feature for emails. This article will introduce how to make it realized via Outlook VBA. As we all know, Outlook permits us to send emails at a scheduled time by means of “Delay Delivery” feature, like the following screenshot: However, this feature is only available for emails, not for meetings or tasks. Thus, many people are looking...

Read more »