1. Use Excel macros: If you are familiar with Excel macros, you can use macros to write codes to read multiple Excel files and extract data.
2. Use the MID function: If you want to extract the content in the middle of the text, you can use the mid function. For example, to extract the three characters from the fourth position in the D2 cell, you can enter the formula = mid (d2,4,3).
3. Use Python or R: You can use programming languages such as Python or R to read Excel files and extract data. These languages have ready-made libraries that can support reading Excel files, such as Pandas and openpyxl.