How to use the Excel MID function

When using WPS Spreadsheets to process data, sometimes we need to catch part of the data from a series of numbers. We can use the MID formula to realize it, to catch up a certain length of characters from a series of numbers. In this example, there is a list of phone numbers. The MID function can extract the long series of numbers, keeping the last seven numbers when removing the first three characters. Select cell D2 and click the Insert Function to pop up the Search for a function d....

Ctrl+E smart filling

After getting in touch with WPS, we know that Ctrl+C copy and Ctrl+V paste are two shortcuts, which can easily improve office efficiency. Few people know about Ctrl+E smart filling, which can intelligently identify the pattern by comparing the characters’ relationship and quickly fill cells. Next, I will introduce the usage of the smart filling shortcut key Ctrl+E. · 1. Extract charactersIn this table, we want to extract all the names in the sentences. First, enter the name that appear....

How to insert shapes in WPS Writer

Inserting patterns and shapes can increase the aesthetics of the document. Take this document as an example. We can add shapes to make workflow diagrams. For all, easy your work with WPS Writer. First, click the Insert tab, and click the Shapes button. In the selection list, we can see different categories, namely Lines, Rectangles, and Basic Shapes, Block Arrows, Equation Shapes, Flowchart, Stars and Banners and Callouts. These shapes can be selected according to personal needs. In th....

TEXT formula in WPS Spreadsheet

The TEXT formula in Excel is commonly used for the conversion of number-to-text in a certain format, and it could be also used in Microsoft Office Excel and Openoffice. Normally, the TEXT formula is used to customize format cells in terms of actual needs. To realize it, we need to adjust the second parameter of the formula, which stands for format texts to be set. In this example, the number 2.012584, which equips with six decimal places, entered cell A2. How can we convert it into a v....

How to insert a chart and edit the chart data

When we organize the data of the document, we usually insert a chart for a supplementary explanation.Take this document as an example. The table in the document represents the annual sales volume of different regions. Now, let's look at the data comparison more intuitively by inserting a bar chart. Go to the Insert tab and click the Chart button. In the pop-up dialog, we can choose a variety of chart types. Click Bar and Stacked Bar, then a default style stacked bar is inserted int....