312 results for how to combine 2 pdfs
- All Tutorials
- Video Tutorials
- Quick Tutorials
How to combine first and last names
How can we merge different cells while keeping all contents inside? Follow these few steps.Suppose that we need to combine the contents in cell B3 and C3. 1. Enter =A3&B3 in cell D3.2. Then you’ll find the the first and last name combined in cell D3. However, we know that there should be a space between each first and last name. Can we realize it?1. Enter =A3&" "&B3 in cell D3. (Note that there should be a space within the pair of quotation marks, regarding the language habits of Engl....
Combine the SUBSTITUTE and LEN functions02:57
Combine the SUBSTITUTE and LEN functions
Here is a form recording the personal information of staff. How can we calculate the staff number for each department?We can combine the LENS and SUBSTITUTE functions to realize it. Before starting, let me introduce the LEN function. It can return the character number of the text.Select cell A4. Go to the formula editing box for the Insert Function button, and choose the LENS function.Since we want to know the character number in cell A2, we need to enter “A2” as the TEXT parameter. Cl....
Multiple methods of merging cells03:17
Multiple methods of merging cells
When we use the WPS Spreadsheet, we often need to merge and combine multiple cells. Merge and Center in WPS spreadsheet offers multiple merging methods. We will explain in detail how to use this function. · Merge and CenterSelect the cell area to be merged, click Home and find the drop-down menu of Merge and Center, and select Merge and Center or press keyboard shortcut Ctrl+M. In this way, the selected cells can be merged into one cell and displayed in the center. · Merge CellsSelect ....
How to convert PDFs to images
Sometimes we need to convert a PDF file to a image. With WPS PDF, you can easily perform the conversion. Here are the steps.1. Open WPS PDF and select PDF to Picture under the Recommend features option. In the pop-up box, browse the PDF you want to convert and click Open. 2. In the Export to Picture box, edit Export Type, Watermark, Page range, format, etc. You can also pay WPS Premium to enjoy high-quality pictures without watermarks or use custom watermark. 3. Then, click Export and ....
How to start page numbers on page 2 in WPS Writer
1. Open the document in WPS Writer.2. Click the Insert tab → and then click the Page Number button.3. In the popup drop-down menu, select Insert Page Number. Then the Insert Page Number dialog box will pop up.4. Here, check Start at Page numbering area.5. Adjust the start number as 0.6. Now click OK. We can now see that the page number of this document is started on page 2. This skill could also be used in Microsoft Office Word and OpenOffice.
How to insert and remove headers/footers in PDFs?
WPS PDF helps quickly add and remove headers and footers to a PDF. Here are the steps.1. Open WPS PDF and click Open PDF under the Create PDF option. Browse the PDF in which you want to insert heades and footers in the pop-up box, select it and click Open. 2. Navigate to the Insert tab and click Header and Footer button. Then select Add Header and Footer. In the pop-up box, you can set the position, content, font, and margins of the header and footer. Note: the following two functions....
INDEX MATCH formulas02:11
INDEX MATCH formulas
In the previous videos, we've learned about the usages of INDEX and MATCH formulas, respectively.The INDEX function can return a value in a cell regarding its column and row number in an array. Combining the INDEX MATCH formulas makes it flexible in value lookup. We can break the limitations of VLOOKUP and realize the reverse lookup. Here is a form recording the personal information of staff. How can we look up the 'Number' of a corresponding staff? We can run the INDEX MAT....
Must-have shortcut tricks in making slides02:24
Must-have shortcut tricks in making slides
During study and work, WPS Presentation is often needed to make a PPT. What makes a high-quality PPT during a short time? In today's tutorials, we will learn a few quick tips commonly used in creating slideshows and thus improving efficiency. · Create a new slideSelect any slide, use the shortcut key Enter, or press Ctrl+Enter together to quickly insert a blank slide. · Delete the current slideSelect the current slide and use the shortcut key Delete or press Ctrl+Delete to remove i....