![需要找到两个细胞之间的相似之处并提取特定的匹配项](https://linux22.com/image/1388638/%E9%9C%80%E8%A6%81%E6%89%BE%E5%88%B0%E4%B8%A4%E4%B8%AA%E7%BB%86%E8%83%9E%E4%B9%8B%E9%97%B4%E7%9A%84%E7%9B%B8%E4%BC%BC%E4%B9%8B%E5%A4%84%E5%B9%B6%E6%8F%90%E5%8F%96%E7%89%B9%E5%AE%9A%E7%9A%84%E5%8C%B9%E9%85%8D%E9%A1%B9.png)
我有两个单元格包含相同的名称,但添加了一些文本。我只想将名称提取到另一个单元格。还需要检查两个单元格是否包含相似的名称....
请帮帮我......
MV RAO -ET-CD-81 ET-M V RAO SUKANTA SAHOO -ET-CD-82 ET-SUKANTA SAHOO SOUMASREE -ET-CD-83 ET-SOUMASREE SEBATI MAHAPATRA -ET-CD-85 ET-SEBATI MAHAPATRA CASH -ET-CD-86 ET-PREM PRAKASH PREM PRAKASH -ET-CD-87 ET-CASH CASH -ET-CD-88 ET-ANURADHA SINGH ANURADHA SINGH -ET-CD-89 ET-PREETIANJALI JAGADEV PREETIANJALI JAGADEV -ET-CD-90 ET-K K KAR KK KAR -ET-CD-91 ET-SRITAM DAS SRITAM DAS -ET-CD-92 ET-MRITYUNJAY KUMAR GAUTAM APARNA RATH -ET-CD-94 ET-TUSHAR RANJAN MOHANTY TUSHAR RANJAN MOHANTY -ET-CD-95 ET-ASUTOSH MOHANTY