excel提取单元格内特定字符（字/词）前（后）的内容

文本	需要提取的内容	得到的结果
search for <bird food> rice corn, cardinal lover <bird tray> for wild animals	1. 需要提取 <bird food> 之前的所有字符和单词	search for
	2. 需要提取<bird food> 和 <bird tray> 之间的所有字符和单词	rice corn, cardinal lover
	3. 需要提取<bird tray> 之后的所有字符和单词	for wild animals
	4. 需要提取<bird food> 之后的所有字符和单词	rice corn, cardinal lover <bird tray> for wild animals

 

公式如下：

D2=TRIM(LEFT(SUBSTITUTE(A2,"<bird food>",REPT(" ",99)),99))
D3=TRIM(MID(SUBSTITUTE(SUBSTITUTE(A2,"<bird food>",REPT(" ",99)),"<bird tray>",REPT(" ",99)),99,99))
D4=TRIM(RIGHT(SUBSTITUTE(A2,"<bird tray>",REPT(" ",99)),99))
D5=TRIM(RIGHT(SUBSTITUTE(A2,"<bird food>",REPT(" ",99)),99))