How to Extract the First Two Words from a White-space-separated String

Problem description & analysis

Below is Excel file book1.xlsx:

undefined

We are trying to extract words from A1’s string, get the first two and concatenate them with the white space, as shown below:

undefined

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.

 

Q & A Collection

https://stackoverflow.com/questions/64232449/is-there-a-way-to-use-an-if-statement-in-excel-to-return-a-persons-name-if-it-i