我有兩個包含相同名稱和一些添加文字的單元格。我只想將名稱提取到另一個單元格。並且還需要檢查兩個單元格是否包含相似的名稱...
請幫幫我…
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-SEBATIHAPATRA CASH - MAETHAPATRA CASH - MAETHAPATRA CASH - MAETHAPATRA CASH - MAETHAPATRA CASH - MAETHAPATRA CASH - MAETHAPATRA CASH - MAETHAPATRA CASH - MAETHAPATRA CASH - MAETHAPATRA CASH - MAETHAPATRA CASH - MAETHAPATRA CASH - MAETHAPATRA CASH - MAETHAPATRA CASH - MAETHAPATRA CASH - MAETHAPATRA CASH - MAETHAPATRA CASH - MAETHAPATRA CASH -CD-86 ET-PREM PRAKASH PREM PRAKASH -ET-CD-87 ET-CASH 現金-ET-CD-88 ET-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 RANJ -ET-CD-94 ET-TUSHAR RANJAN MOHANTY TUSHAR RANJ -ET-CD -95 ET-阿蘇托什·莫漢蒂