Extract the second row of data in an Excel 2013 line-wrapping cell

Case Teaching

① start Excel2013, open the table you want to extract, and see a lot of newline cells in column D, I'm going to extract the second row of data and enter the formula in the E2 cell: =replace (D2,1,find (CHAR, D2), "")

② carriage return, get results Zhuhai. Detailed description of the formula, I at the end of the article for you to give a detailed introduction.

③ for easy input, the following use cell Fill method to complete the rest of the operation, move the mouse to the lower right corner of the E2 cell, the + number, double-click, you can quickly fill up.

Formula description

Replace (the text to be replaced, replaced by the first few of the text, how many to replace, and why): Use a different text string and replace part of the text in a text string based on the number of characters you specify.

Find (what to look for, where to find): Returns the position of the find content in the text.

CHAR (10): line feed.

First, use the Find function to locate the line break position 3 in the D2 cell, and then replace the D2 cell with the first character, replacing 3.

Classification:

• Excel Tutorials