Quickly extract text information from Excel 2010 cell Brackets

Example Demo

① we open an Excel spreadsheet, we're going to extract the bracketed contents of column C into column D, click D2 Cell, and enter the following formula: =mid (C2,find ("() +1,len (C2)-find (" ("C2)-1)

② input complete, press ENTER, enter, get results Shenzhen. If you do not get the correct results, to see if the formula is the English half-width state input, otherwise it will be wrong!

③ is still using the method of cell padding to complete the remaining data entry. In this way, we have extracted the contents of a cell bracket.

Formula description

Mid (where to fetch, starting from the first few): The specified character (text) is taken from the specified string (text).

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

Len (cell reference): Counts how many words are in a cell.

First, use the Find function to locate the "(" position in C2 3, plus 1 results are 4, second, Len calculates the text length of the C2 cell 6, minus 3, minus 1, and the result is 2. Finally, the mid function in the C2 cell, from the 4th start, take 2, to extract the contents of the parentheses in "Shenzhen", Note that parentheses must be entered in the English half-width state.

Classification:

• Excel Tutorials