- Image and text skills
When using the table search function, you often encounter some fuzzy information search matches.
If the content includes cola search, etc., it is often necessary to use wildcards in the WPS table.
Wildcard, as the name suggests, is a universal matching character, which can replace any character.
￭Take this form as an example, Question mark (?) represents any single character, that is, how many indivual? Just match as many characters as possible.
Suppose we want to view the four characters starting with "Coke".
Use the search shortcut key Ctrl+F. A search dialog box will pop up. Enter "Coke??" in the search content.
Click "Options" and check "Cell Match". The result we can see is "Coke Sprite".
￭The asterisk (*) represents any number of characters, including 0 characters, if we want to view the characters starting with "can".
Use the search shortcut key Ctrl+F. A search dialog box will pop up. Enter "can*" in the search content.
Click "Options" and check "Cell Matching",The result we can see is< /span>"Cola wine", "Cola Sprite", "Cola cocktail".
￭The tilde character (~) represents that the wildcard character on the right side of the tilde character is converted into a normal character (that is, it is not used as a wildcard character).
Take "~*" as an example, convert * into a normal character *, and use the search shortcut key Ctrl+F.
The search dialog box will pop up, enter "~*" in the search content.
The results we can see are "*Coca-Cola" and "Lemon*Cola". Have you learned it?
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/biao-ge-xin-shou-jiao-cheng-ru-he-zai-biao-ge-zhong-shi-yong-tong-pei-fu.html
支付宝扫一扫 
评论列表（196条）
测试