单元格如何提取英文字母并去掉特定字符

富有韩_Ton

目标:
识别相似项(相似内容)
举例: 下面表格里2-3，4-5，6-7，8-9分别是相似内容，另外还有其他大量的行，还有

方法:
公式或者VBA

需求: B列只提取A列单元格的英文字符，然后将"and", "R","S","X","D"字符去掉
我想到的方法是：1）提取单元格的特征signature；2）判断特征signature，如果相同，则表明单元格相同或者相似。
如何提取特征：B列只提取A列单元格的英文字符，然后将"and", "R","S","X","D"字符去掉

富有韩_Ton

A列文本如下：

1. Additional IPsec encryption algorithms added to support IPsec update data path processing (MX Series)—Starting in Junos OS Release 15.1, you can configure three new IPsec encryption algorithm options for manual Security Associations at the [edit security ipsec security-association sa-name manual direction encryption] hierarchy level: aes-128-cbc, aes-192-cbc, and aes-256-cbc.
   
2. Additional IPsec encryption algorithms added to support IPsec update data path processing (MX Series)—Starting in Junos OS Release 15.1R1, you can configure three new IPsec encryption algorithm options for manual Security Associations at the [edit security ipsec security-association sa-name manual direction encryption] hierarchy level: aes-128-cbc, aes-192-cbc, and aes-256-cbc.
   
3. RADIUS VSAs in output of test aaa command when authentication is unsuccessful (MX Series)—Starting in Junos OS Release 13.2R3, when you run the test aaa command, the command output includes all subscriber attributes when authentication is unsuccessful. In previous releases, the test aaa command returned a partial list of attributes when authentication was unsuccessful.
   
4. RADIUS VSAs in output of test aaa command when authentication is unsuccessful (MX Series)—Starting in Junos OS Releases 13.2R3 and 14.1R1, when you run the test aaa command, the command output includes all subscriber attributes when authentication is unsuccessful. In previous releases, the test aaa command returned a partial list of attributes when authentication was unsuccessful.
   
5. Asynchronous single hop BFD support for IP liveness detection (MX Series)—Starting in Junos OS Release 15.1, Bidirectional Forwarding Detection (BFD) supports Layer 3 liveness detection of IP sessions between the broadband network gateway (BNG) and customer premises equipment (CPE). You can show all BFD sessions for subscribers using the show bfd subscriber session operational mode command.
   
6. Asynchronous single hop BFD support for IP liveness detection (MX Series)—Starting in Junos OS Release 15.1R1, Bidirectional Forwarding Detection (BFD) supports Layer 3 liveness detection of IP sessions between the broadband network gateway (BNG) and customer premises equipment (CPE). You can show all BFD sessions for subscribers using the show bfd subscriber session operational mode command.
   
7. Control word feature for LDP VPLS and FEC129 VPLS (MX Series)— Starting with Junos OS Release 14.2R4, the control word feature is supported for LDP VPLS and FEC129 VPLS.
   
8. Control word feature for LDP VPLS and FEC129 VPLS (MX Series)— Starting with Junos OS Release 16.1, the control word feature is supported for LDP VPLS and FEC129 VPLS.
   
9. Extended cable manager for EX9214 switches—An extended cable manager is now available for EX9214 switches. The extended cable manager enables you to route cables away from the front of the line cards and Switch Fabric modules and provides easier access to the switch than offered by the standard cable manager. To obtain the extended cable manager, order the MX960 Enhanced Cable Manager, ECM-MX960. (Note that installation of the extended cable manager must be done by a Juniper Networks-authorized technician and that the service cost is in addition to the component cost.) [See MX960 Cable Manager Description.]
   
10. "Uniform Enhanced Layer 2 Software CLI configuration statements and operational commands—ELS provides a uniform CLI for configuring and monitoring Layer 2 features on EX Series switches that support ELS, such as EX9200 switches and EX4300 switches, and on MX Series routers in LAN mode (MX-ELM). With ELS, for example, you can configure a VLAN and other Layer 2 features on an EX9200 switch, an EX4300 switch, or an MX-ELM router by using the same configuration commands. [See Getting Started with Enhanced Layer 2 Software.]
    
11. The Web-based ELS Translator tool is available for registered customers to help them become familiar with the ELS CLI and to quickly translate existing EX Series switch–based CLI configurations into ELS CLI configurations. [See ELS Translator.]"
    
12. "Enhanced Layer 2 Software storm control on EX9200 switches—EX9200 switches support storm control. Storm control enables the switch to monitor traffic levels and to drop broadcast, multicast, and unknown unicast packets when a specified traffic level—called the storm control level—is exceeded, thereby preventing packets from proliferating and degrading the LAN.
    
13. Storm control is enabled by default on all Layer 2 interfaces. You can modify the storm-control configuration with a two-step process:
    
14. * Configure a storm-control profile at the [edit forwarding-options] hierarchy level.
    
15. * Bind the storm-control profile to a specific logical interface or to a group of logical interfaces. The group can include a range of interfaces or all interfaces on the switch."
    
16. DHCP servers can process packets without Option 255 (EX9200)—On EX9200 switches, starting with Junos OS Release 13.2R6, you can override the configuration on a DHCP local server in order to enable the server to process DHCP packets that are sent from the client without Option 255 (end-of-options). The default behavior in Junos OS, for the DHCP local server, is to drop packets that do not include Option 255. To override the default behavior, configure the allow-no-end-options CLI statement at the [system services dhcp-local-server overrides] hierarchy level.
    
17. MAC address synchronization for a multichassis link aggregation group on EX9200 switches—When you enable Layer 3 unicast functionality across an MC-LAG on an EX9200 switch, you can now synchronize the MAC addresses for IRB interfaces assigned to a specified VLAN, which participates in the MC-LAG. To synchronize the MAC addresses for the IRB interfaces assigned to a VLAN, use the mcae-mac-synchronize statement at the [edit vlans vlan-name] hierarchy level. [See Configuring Multichassis Link Aggregation.]
    
18. Enhanced Layer 2 Software native analyzer support on EX9200 switches—Support for native analyzers and remote port-mirroring capabilities. On EX9200 switches, the analyzer configuration is available at the [edit forwarding-options] hierarchy level. A native analyzer configuration contains both an input stanza and an output stanza in this analyzer hierarchy level for mirroring packets. In remote port mirroring, the mirrored traffic is flooded into a remote mirroring VLAN that can be specifically created for the purpose of receiving mirrored traffic. [See Understanding Analyzers on EX9200 Switches.]
    

复制代码

富有韩_Ton

A列文本如上，需求：B列只提取A列单元格的英文字符，然后将"and", "R","S","X","D"字符去掉