Word和Excel中查找替换通配符使用方法详解(国外英语资料).doc

Word和Excel中查找替换通配符使用方法详解(国外英语资料) Word and Excel find and replace wildcard using detailed methods of _ Wildcards are special sentences that are used primarily to blur search and replace. In Word, using wildcards Excel can find and replace text, format and paragraph marks, carriage return, break (the end of a page and page breaks: the start position of the next page. You can use wildcards and code to extend search. Clear the use of wildcards check box in Word and Excel Any single character ^? Random number: ^# Any English letters: ^ $ Paragraph marker: ^p Manual line break: ^l Graphics: ^g, or, ^1 1/4 long line: ^+ Long line: ^j Short line: ^q Tab: ^t Off size: ^ Break: ^v Segmented characters: ^b Ellipsis: ^n Full width: ^i ellipsis No width without delimiter: ^z No width optional delimiter: ^x Uninterrupted space: ^s Uninterrupted hyphen: ^ ~ ? pilcrow: ^% The section break: ^ Footnote mark: ^f, or, ^2 The optional hyphen: ^ - Blank area: ^w Manual break: ^m Endnote mark: ^e Domains: ^d Unicode characters: ^Unnnn The entire space: ^u8195 ^32 or ^u8194: half space Annotations: ^a, or, ^5 Paragraph marker: ^p Manual newline:: ^l Find the contents shall: Clipboard content: ^c Ellipsis: ^i Full width: ^j ellipsis Tab: ^t Long line: ^+ 1/4 long line (-):^q Dash (-):^= Caret: ^ ^ ^m or ^12: manual page breaks The optional hyphen (_): ^ - Uninterrupted hyphen (-): ^ ~ Uninterrupted space: ^s No width without delimiter: ^z No width optional delimiter: ^x Break: ^n The section break: ^% ? paragraph symbol: ^v Check wildcards in Word and Excel using the wildcard check box Any single character:? Any number (single): [0-9] Any English letter: [a-zA-Z] Paragraph marker: ^13 Manual line feed: ^l, or, ^11 Graphics: ^g 1/4 long line: ^q Long line: ^+ Dash: ^ Tab: ^t Caret: ^ ^ Break: ^n or ^14 Section break / page breaks: ^m Ellipsis: ^i Full width: ^j ellipsis No width without delimiter: ^z No width optional delimiter: ^x Uninterrupted space: ^s Uninterrupted hyphen: ^ ~ Expressio