How to Extract the First Two Words from a White-space-separated String
Problem description & analysis
Below is Excel file book1.xlsx:
We are trying to extract words from A1’s string, get the first two and concatenate them with the white space, as shown below:
Solution & explanation
Excel中加载插件 ExcelRaq.xll 后。Load add-in ExcelRaq.xll in Excel, and
Enter the following formula in cell B1: =esproc("=?.words().to(2).concat("""")",A1) to get results.
SPL Official Website 👉 http://www.scudata.com
SPL Feedback and Help 👉 https://www.reddit.com/r/esProc
SPL Learning Material 👉 http://c.scudata.com
SPL Source Code and Package 👉 https://github.com/SPLWare/esProc
Discord 👉 https://discord.gg/ydhVnFH9
Youtube 👉 https://www.youtube.com/@esProc_SPL