首页 > 其他分享 >How to search for ? (question mark) in Excel

How to search for ? (question mark) in Excel

时间:2023-11-06 14:33:00浏览次数:37  
标签:search wildcard character question How only characters finds

The ? is a wildcard which represents a single character, and the * is a wildcard character that represents any string of characters.

When searching for either wildcard character, Excel will simply find everything, whether or not these actual characters appear in the cells you're searching.

To find either of the specific characters, when not using them in a wildcard search, you must precede it in your search criteria with a tilde, the ~ character.

  • ~? finds only the ? character
  • ~* finds only the * character
  • ? finds all single characters
  • * finds all strings of characters
  • ~~ finds only the ~ character
=========================

REF:
https://superuser.com/questions/458606/how-to-search-for-question-mark-in-excel



标签:search,wildcard,character,question,How,only,characters,finds
From: https://blog.51cto.com/emanlee/8207358

相关文章

  • How can I move a MySQL database from one server to another?
     Myfavoritewayistopipeasqldumpcommandtoasqlcommand.Youcandoalldatabasesoraspecificone.So,forinstance,mysqldump-uuser-ppasswordmyDatabase|mysql-hremoteserver-uremoteuser-premoteserverpasswordYoucandoalldatabaseswithmysq......
  • How to resize slide dimensions without resizing any objects on the slide?
    IFyouarecompetenttounzipthepptxfileandmodifytheXMLitcanbedone,theslidesizewillchangebutthepictureswillnotchange(theywillmovethoughandyouwillhavetoadjustthepositions)Unzip>lookforPPT>presentationXMLandc......
  • How do I run Adobe Flash on Chrome?
     ToenableFlashforaspecificwebsite,firstopenyourChromebrowserandtypechrome://settings/contentintheaddressbar,thenpressenter.ThenontheContentSettingspage,scrolldownandclicktheFlashbuttonMakesurethatthetoggleissetto......
  • Elasticsearch常用命令总结
    Elasticsearch常用命令总结查看集群健康状态-green:每个索引的primaryshard和replica都是active状态,ES集群正常。-yellow:每个索引的primaryshard是active状态,但是部分的replicashard不是active,ES集群可以正常使用。-red:不是所有索引的primaryshard都是active状态,部......
  • Elasticsearch性能优化
    Elasticsearch性能因素总结Elasticsearch性能优化可以分为四个模块来进行,分别是硬件、操作系统、Elasticsearch参数配置以及查询优化。硬件优化在预算充足的情况下。特别是一些高并发业务的搜索。硬件层面占用整个elasticsearch性能空间很大比例。内存根据业务量不同,内存的需求也不......
  • How to prevent salinization of land
    Howtopreventsalinizationofland一.Measures:1.Itcanbeanalyzedandoperatedbylevelingtheland,improvingcultivation,fertilization,sowing,planting,intersticulture,etc.,strengthenthemanagementofChineseagriculturalenterprises,andtry......
  • elasticsearch笔记一
    安装官网链接:[InstallationandUpgradeGuide7.2]|Elastic=》InstallingtheElasticStackhttps://www.elastic.co/guide/en/elastic-stack/7.2/installing-elastic-stack.html系统支持:支持一览表|Elastic启动:sh/usr/local/elasticsearch/bin/elasticsearch-d-p......
  • CTFshow--crypto(1-5)
    crypto1. 直接倒序就可以crypto2. 在crypto中遇到一串未知字符,可以使用CTF在线工具中的JSFuck解密,网址为:http://www.hiencode.com/jsfuck.htmlcrypto3. 遇到一些奇怪的文字时可以先另存为,再查看文件,最后利用aaencode颜文字加密即可crypto4. 直接利用CTF工具中的RS......
  • ctfshow——misc入门(1)
    2打开看见IHDR发现是PNG格式直接重命名,然后用honeyview解出来 3.与第二题解法一样方法思路都是一样的4.利用010editor寻找文件头——通过对比文件头表确定文件类型,再重命名得到文件。png——文件头89504E47jpg——文件头FFD8FFBMP——文件头424DGIF——文......
  • CTFshow Reverse 二进制玩家人均全栈 wp
    是个zip文件,修复一下得到一个”听说大家很怕VMP?”的文件。无法运行,跟标准elf文件比较一下,把头部改3个字节,文件可以跑了upx脱壳,脱壳后进入主函数迷宫在52行的unk_4BE100中,把迷宫提取出来:1,1,0,0,0,0,0,00,1,1,1,0,0,0,00,0,0,1,0,0,0,00,1,1,1,0......