Quickly combine multiple lines of text with WPS text table conversion

Source: Internet
Author: User

The data format downloaded from the Web is often a row of data, and we often need to connect the contents of a large piece of text to one line of text, and sometimes even more rows to the line. Manual copy paste is obviously very troublesome, in fact, in WPS text 2007 to deal with this kind of problem is very simple. The following is a WPS 2007 people version of the WPS text to introduce the specific operation.

1. Start WPS Text 2007, click "File/Open" On the menu, select file Type "All Files (*.*)" In the open window, and then locate the txt text file you want to process to open.

2. Press "CTRL + a" key to select the full text, click the menu "table → convert → text into a table," in the pop-up "Convert Text to Table" dialog box, set the number of columns to 2, text-separated position for paragraph marks, determine complete conversion. You can immediately see the two lines merging into one row, but there are more table borders.

3. Press CTRL + A again to select all, click menu "table → convert → table to text", set the text separator to "other characters" in the "Convert Table to Text" dialog box, and enter ":" In the following input box, to determine the completion of the conversion. You will soon see the effect of the two-row merge shown in Figure 1. In fact packages to open is TXT format text file, this step conversion can be omitted, simply save directly will automatically eliminate the table, but directly saved in the document two lines of text is not ":" Delimited.

This is a simple method, isn't it? In step 2nd, if you set the number of columns to 3 or greater, you can easily combine three or more rows. In addition, this method can not only quickly achieve multiple lines of stitching, but also free to adjust the sequence of the lines, such as we can make the 2nd row of content in front of line 1th. Just insert a column in front of the first column of the table after the 2nd step into two columns, then select the original 2nd column to cut and then select the 1th column to paste, 3lian.com, so that when the table is converted to text, the contents of the 2nd line are in front of the 1th line.

Note: This move slightly changes can also achieve the 1th, 3rd Line merged into a row, the 2nd, 4th Line merged into another row of the cross-row merge effect, this left to everyone to study it.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.