怎么把excel表格去掉

1.EXCEL如何条件删除?

问题如下，怎么批量去掉前面的5501XXXX 55010101 CA1140 55010102 CA1141T2 55问题如下，怎么批量去掉前面的5501XXXX55010101 CA1140 55010102 CA1141T2 55010103 CA1141K2T2 55010104 CA1150K2T1 55010105 CA1170P2K1L2 55010106 CA6105 55010107 CA11609T 55010108 CA116014T 55010109 CA6110 55010110 CA6113 55010111 CA1246P1K14L9T1 55010112 CA1240P2K14T 55010113 CA1241P2K14T 55010114 CA1228P1K2L7T1 55010115 CA1150PK2L2T1 55010116 CA1310 55010117 CA1171 55010118 CA1258 55010119 CA6D22 55010120 CA1225P1K2L7T1 55010121 CA1246 55010122 CA1260。