Office File Recovery

The Difference between Excel Built-in ROUND Function and VBA ROUND Function

Excel functions can help you a lot in your work. In this article, we will discuss about the difference between the built-in ROUND function and the VBA ROUND function. You will certainly have used the ROUND function in your Excel. If you also use VBA to finish some tasks, you may also have used the ROUND function in codes. However, the built-in ROUND functions in worksheet and in VBA codes work differently. Below we will show you how they work differently. Built-in ROUND Function In this...

Read more »

4 Effective Ways to Set Hyphenation for the Texts in Your Word Document

In the bellowing content, there will be 4 ways available for you to set hyphenation for the texts in your Word document. From time to time, we will meet the case where Word automatically generate a line break whenever it determines there is no enough space for the last long word. Consequently, the long word will go to next line, leaving a large space behind the last line. This absolutely looks no good. Luckily, Word has already offered us the “Hyphenation” option. Read on and see how...

Read more »

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 »