#excel#
手机号码都是11位数,那如何批量删除位数不正确的手机号码?
在C2单元格输入“=len(B2)=11”→填充下拉→选中第二行,按“Ctrl+Shift+L”进入筛选状态→将显示“FALSE”的筛选出来→单击鼠标右键,选择“删除”
温馨提示:公式“=len(B2)=11”是一个逻辑判断,等于“11”则为“TRUE”,否则为“FALSE”
手机号码都是11位数,那如何批量删除位数不正确的手机号码?
在C2单元格输入“=len(B2)=11”→填充下拉→选中第二行,按“Ctrl+Shift+L”进入筛选状态→将显示“FALSE”的筛选出来→单击鼠标右键,选择“删除”
温馨提示:公式“=len(B2)=11”是一个逻辑判断,等于“11”则为“TRUE”,否则为“FALSE”
[月亮][每日译句]
And I shall remain satisfied, and proud to have been the first who has ever enjoyed the fruit of his writings as fully as he could desire; for my desire has been no other than to deliver over to the detestation of mankind the false and foolish tales of the books of chivalry, which, thanks to that of my true Don Quixote, are even now tottering, and doubtless doomed to fall for ever. Farewell.
现在,我首先享受到了这种成果,已经心满意足。由于我这本关于唐吉诃德的真实故事,骑士小说将日趋衰落,并且最终将彻底消亡。再见。
——《Don Quijote de la Mancha》Miguel de Cervantes Saavedra《唐·吉诃德》塞万提斯·萨维德
[心]晚安~#翻译硕士#
And I shall remain satisfied, and proud to have been the first who has ever enjoyed the fruit of his writings as fully as he could desire; for my desire has been no other than to deliver over to the detestation of mankind the false and foolish tales of the books of chivalry, which, thanks to that of my true Don Quixote, are even now tottering, and doubtless doomed to fall for ever. Farewell.
现在,我首先享受到了这种成果,已经心满意足。由于我这本关于唐吉诃德的真实故事,骑士小说将日趋衰落,并且最终将彻底消亡。再见。
——《Don Quijote de la Mancha》Miguel de Cervantes Saavedra《唐·吉诃德》塞万提斯·萨维德
[心]晚安~#翻译硕士#
营造历
河北承德普宁寺喇嘛塔/清
单向历
I believe it is an established maxim in morals that he who makes an assertion without knowing whether it is true or false, is guilty of falsehood.
—Letter to Allen N. Ford, Politician, Abraham Lincoln
我信奉一个公认的道德准则:在不明真假的情况下就妄下断言,都有不实之嫌。
——《给艾伦·福特的一封信》亚伯拉罕·林肯,政治家
在浮躁的网络世界里谨言慎行,对我们每个人来说都是一道考验。下一次,在发表评论之前,在做出判断之前,想一想林肯的这句话吧。也许,在不明真相的情况下,自以为的伸张正义,其实是另一种形式的网络暴力。
河北承德普宁寺喇嘛塔/清
单向历
I believe it is an established maxim in morals that he who makes an assertion without knowing whether it is true or false, is guilty of falsehood.
—Letter to Allen N. Ford, Politician, Abraham Lincoln
我信奉一个公认的道德准则:在不明真假的情况下就妄下断言,都有不实之嫌。
——《给艾伦·福特的一封信》亚伯拉罕·林肯,政治家
在浮躁的网络世界里谨言慎行,对我们每个人来说都是一道考验。下一次,在发表评论之前,在做出判断之前,想一想林肯的这句话吧。也许,在不明真相的情况下,自以为的伸张正义,其实是另一种形式的网络暴力。
✋热门推荐