Office Solutions

2 Effective Methods to Extract Numbers from Your Excel Cells

In an Excel worksheet, you may need to extract numbers from values in cells. And in this article, we will introduce you two methods to extract numbers from Excel cells. There are many cases that both numbers and texts are in same cells. In order to better analyze those values, you will need to extract the numbers and texts. The image below shows such an example. In column A, there are the ID and the name of products. Now you need to input the product ID into column B in the worksheet. And...

Read more »

How to Remove the Space Characters in the Penultimate Positions in Excel Cells

In the process of copying and pasting, there will sometimes be space characters in cells. In this article, we will show you an example of the space characters in the penultimate positions. When you are working on an Excel worksheet, you will sometimes meet with problems. One of the problems is that there will be additional space characters in cells. You will certainly need to remove those useless spaces. If you remove spaces one by one, you will spend a lot of time and energy. But on the...

Read more »

How to Always Open Specific Folders When Switching Between Different Outlook Sections

When you switch between different sections, no matter Mail, Contacts, Calendar or Tasks, Outlook will always open its default folder. If you want to configure Outlook to always open specific and non-default folders, you can use the method introduced in this article. As usual, when you switch to Mail section, Outlook will open its default folder in the “Favorites” group. Actually, for the default mail folder, you can easily change it in Outlook Options, like the following...

Read more »