Editing MySQL full text search equivalents to Google search (section)

=== Microsoft  Spreadsheet approach ===
Using [https://support.office.com/zh-tw/article/FIND%E3%80%81FINDB-%E5%87%BD%E6%95%B8-c7912941-af2a-4bdf-a553-d0d89b0a0628 FIND], [https://support.office.com/zh-tw/article/MID%E3%80%81MIDB-%E5%87%BD%E6%95%B8-d5f9e25c-d7d6-472e-b568-4ecb12433028 MID] & [https://support.office.com/zh-tw/article/CONCATENATE-%E5%87%BD%E6%95%B8-8f8ae884-2ca8-4f7a-b093-75d702bea31d CONCATENATE] functions. {{exclaim}} FIND function is case-sensitive!
<table border="1">
   <tr>
      <td></td>
      <td>A</td>
      <td>B</td>
  </tr>
   <tr>
      <td>1</td>
      <td>文章</td>
      <td>笑傲江湖中嵩山派掌門左冷禪所創掌法，可發出至陰至寒的真氣。左冷禪與任我行比武時，以此功對付吸星大法，使其全身凍僵、天池穴被封;與岳不群比劍奪帥時，左又使出寒冰神掌，與紫霞神功旗鼓相當、不分勝敗。

原文網址：https://kknews.cc/zh-tw/culture/xzaxbq.html</td>
  </tr>
   <tr>
      <td>2</td>
      <td>關鍵字</td>
      <td>吸星大法</td>
  </tr>
   <tr>
      <td>3</td>
      <td>搜尋結果摘要</td>
      <td>{{kbd | key=<nowiki>=IF(ISERROR(FIND(B2, B1)), "", CONCATENATE(MID(B1, IF(FIND(B2, B1)-10 >= 1, FIND(B2, B1)-10, 1), 10), MID(B1, FIND(B2, B1), 10+LEN(B2))))</nowiki>}}</td>
  </tr>
</table>

[https://docs.google.com/spreadsheets/d/1ij-50vYqRXJwM71OEWXZHJzrkYfpZYCK-0MFJ3jvY1E/edit?usp=sharing Try it online]