Microsoft Office: Difference between revisions

From Moscow American Travis Lee Bailey Internationally the United States is the most violent country immigrate to Russia choose your big brother wisely
Jump to navigation Jump to search
No edit summary
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{tech}}
===Microsoft Word Quick Access Toolbar not working, all greyed out===
https://answers.microsoft.com/en-us/msoffice/forum/all/quick-access-toolbar-not-working-all-greyed-out/af5a29f6-ce0e-481d-9d86-5b9f58f88f7b
 
{{template:tech}}
 
 
== Microsoft Finding and replacing characters using wildcards ==
== Microsoft Finding and replacing characters using wildcards ==
# https://wordmvp.com/FAQs/General/UsingWildcards.htm
# https://wordmvp.com/FAQs/General/UsingWildcards.htm

Latest revision as of 06:13, 1 February 2024

Microsoft Word Quick Access Toolbar not working, all greyed out

https://answers.microsoft.com/en-us/msoffice/forum/all/quick-access-toolbar-not-working-all-greyed-out/af5a29f6-ce0e-481d-9d86-5b9f58f88f7b

Send a free fax

https://www.lifewire.com/free-fax-services-2378048

Wiki family Wiki Farm

Wiki Farm

Copy cyrillic webpage names

https://www.webatic.com/url-convertor

Calendar

https://www.calendarpedia.com/calendars/october-2022-calendar.html

VPN

FREE VPN for Windows PC Download in 2021 - BETTERNET.co - entire internet

Download programs

windows 10 change mouse visible

Make your mouse more visible by changing the color and size of the mouse pointer.

Start button

Settings >

Ease of Access >

Cursor & pointer , and

choose the options that work best for you.

Desktop programs downloaded and installed

Programs downloaded



Bulk rename utility Bulk file rename utility

Firefox Need to get rid of "ImportEnterpriseRoots" Certificate

https://www.reddit.com/r/firefox/comments/utbtdl/need_to_get_rid_of_importenterpriseroots

The two ways to lock a preference are:

(1) Enterprise Policy -- check about:policies

This can be done by dropping a file: https://support.mozilla.org/kb/customizing-firefox-using-policiesjson

(2) Autoconfig

This is done by dropping two files: https://support.mozilla.org/kb/customizing-firefox-using-autoconfig

What is "ImportEnterpriseRoots" Certificate

https://support.mozilla.org/en-US/questions/1306557

This is a pretty common question that gets asked here.

The ImportEnterpriseRoots policy is setup by a lot of security programs (antivirus, firewall, etc). Security programs often use this policy so that they can view incoming secure connections to check that the content is safe, without triggering error messages in Firefox.

That policy has no impact on what settings you will be able to use in Firefox. It will cause the "Your computer is being managed by your organization" warning message to appear on top of the settings page, but that's it.

Removing that policy from your computer often causes your security program to stop working and/or will cause issues in Firefox when loading some websites.

Hope this clears things up for you.


Telegram

Telegram discussion group with "chat history for new members"

Called Discussion button

scrape users in telegram

Export telegram contacts on pc windows

How to Export Telegram Contacts and Group Members (PC) Download and install Telegram for Windows/Mac on PC.

Launch Telegram on your PC and login to your account using Phone Number or QR code.  

After successful login, it will take you to the Dashboard where you find the list of the conversations, here

  1. tap on the three lines icon at the top on PC.
  2. It will open a new menu with the list of options, select Settings.
  3. Next, click on Advanced as shown in the below image.
  4. Scroll down to the last and tap on the Export Telegram Data.
  5. After that, select the data you want to export from Telegram. Just select the Account Information and Contact list option.
  6. Scroll down and select the location where you want to download the data and select Human-readable HTML format. Tap on the Export.

upload video anonymously drag and drop

https://www.thewindowsclub.com/free-anonymous-file-sharing-services-which-allow-you-to-share-files-without-creating-an-account

https://www.veed.io/send-video

VLC MEDIA PLAYER

VLC


How to Take Batch Screenshots or Screencaps in VLC Media Player

FEB 1, 2021

https://turbofuture.com/computers/How-to-take-batch-screenshots-or-screencaps-in-VLC-Media-Player

ActivePresenter

Record screen with video.

Excellent! Downloaded from RuTracker.org August 28 2022 only 44 MB.

https://rutracker.org/forum/viewtopic.php?t=6002607

How to Export ActivePresenter Projects to Videos

https://atomisystems.com/tutorials/export-activepresenter-projects-videos/

8 Best Screen Recorders for Windows 10 in 2022- Free & Paid

https://atomisystems.com/screencasting/record-screen-windows-10/

Bulk converting audio files into one

DOESNT WORK

VSDC Pro Video Editor 7.1

RuTracker.ORG

19 Best Free Software to Batch Convert WMA To MP3 for Windows https://listoffreeware.com/free-software-batch-convert-wma-to-mp3-windows/

AnyMP4 MXF Converter 8.0.10 RePack (& Portable) by TryRooM [2020,Multi/Ru]

https://rutracker.org/forum/viewtopic.php?t=5956123

https://www.google.com/search?q=unlock+%22wma%22+protected+files


10 ways to bulk convert audio files into one

From: https://multimedia.easeus.com/video-editing-tips/audio-joiner.html#part3

3. Copy Command on Windows

Platform: Windows

Windows allows you to merge audio from the command prompt. Here is the command you can use is as follows:

copy /b *.mp3 c:\merged.mp3

The command above means it will find all MP3 files in the directory and join them into the merged.mp3 file.

If you want to add only a few files add them accordingly using a "+" sign in between.

Pros

No need to install a software

The simplest way to merge audio files without losing quality

Cons

Not possible to edit the files

No way to change the format of the output file

Cumbersome to use.

VLC

Source: https://www.videoproc.com/audio-editor/best-audio-mergers.htm


3. How to Merge MP3 Files on Windows 10 with VLC

VLC is an open-source free program that you can free access to. Based on its introduction of how to merge videos, we have tested its capability of combining audio files, and it turns out to be feasible as well. Before we kick off, you need to make sure that all of your audio files have the file extension of .mp3. Otherwise, this method may not work for you. (Notice: if you have different formatted audio files such as .flac and .mp3, see the workaround.)

Step 1. Download and install VLC on your computer.

You are recommended to install VLC locally by its default route.

Step 2. Use the keyboard shortcuts

Win+X > click Command Prompt in the pop-up list.

Or, use the hotkey combination

Win+R to open Run >

type cmd in the box >

hit Enter

Then the Command Prompt will be opened as well.

Run Command Prompt

[Win+R] > cmd to run Command Prompt

Step 3. In the Command Prompt, enter the command: cd c:\mp3, then hit the Enter key.

Sidenote: The c:\mp3 command is the file folder directory where your mp3 audio files are kept. If your audio files are kept on C disk, c:\ file location

Step 4: There will be c:\mp3> command already existing, copy and paste commands as follows:

"C:\PROGRAMFILES\VideoLAN\VLC\vlc.exe" -vv 1.mp3 2.mp3 --sout-keep --sout=#gather:transcode{acodec=mp3,ab=128}:standard{access=file,mux=dummy,dst=combinedout.mp3}

Sidenotes:
1. C:\PROGRAMFILES\VideoLAN\VLC\vlc.exe command refers to the directory path where the VLC launching program is located in your Windows computer, which is also the default path of VLC setup. Change it if you've set a different destination path for your VLC installation.
2. The 1.mp3 2.mp3 command refers to the filename of your audio tracks. Customize the part based on your personal demands.
3. The combinedout.mp3 command refers to the file name of the combined file. You can change it to the one you like.

Reset password Change or reset your Windows password

Select Start >

Settings >

Accounts >

Sign-in options .

Under Password, select the Change button and follow the steps.

https://www.rbth.com/articles/2011/12/07/a_rewarding_challenge_13919.html


Download youtube videos in bulk

YouTube Playlist: How to Download YouTube Videos in Bulk

https://gadgets360.com/how-to/features/download-youtube-videos-playlist-bulk-computer-phone-4k-video-downloader-videoder-2279719

Try 4K Video Downloader Today! EXCELLENT

Free Video Downloader Trusted by Millions

https://www.4kdownload.com/products/videodownloader/21


Download YouTube videos that you've uploaded BASTARDS

https://support.google.com/youtube/answer/56100?hl=en

how to burn a disk

How to Burn a CD or DVD on Windows 10 https://www.howtogeek.com/689705/how-to-burn-a-cd-or-dvd-on-windows-10/

GRAMFILE

https://gramfile.com/active-iso-burner-download/

Ashampoo Burning Studio Free 1.23.8.0

https://www.majorgeeks.com/mg/getmirror/ashampoo_burning_studio_free,1.html


HP INK TANK WIRELESS

How do I switch between ink tank and cartridge on HP Ink 410 series ?

I want to disable the use of the ink cartridges completely.

Is there any articles or videos on how the HP ink cartridge works when there is tank?  I wanted to buy a printer WITHOUT a ink cartridge.  I did not realize there are  two expensive to replace  ink cartridges inside.

https://h30434.www3.hp.com/t5/Printing-Errors-or-Lights-Stuck-Print-Jobs/How-do-I-switch-between-ink-tank-and-cartridge-on-HP-Ink-410/m-p/8414833#M951251

Download whatsapp messages in bulk batch

https://www.unictool.com/whatsapp/export-all-whatsapp-chats-at-once/


4 Efficient Methods to Export WhatsApp Chats to PDF

https://mobiletrans.wondershare.com/whatsapp-tips/export-whatsapp-chat-pdf.html

whatsapp viewer

https://andreas-mausch.de/whatsapp-viewer/

Download all whatsapp contacts in a whatsapp group video

How to Export WhatsApp Group Contacts to Excel? https://www.youtube.com/watch?v=ll26Ha2Xfs0&t=67s

https://www.youtube.com/watch?v=ll26Ha2Xfs0&t=67s

Shortcuts for chrome webpages

File:Create shortcut on chrome photo.png

subtitles and closed caption freeware

Subtitle Editor

https://nikse.dk/subtitleedit

Subtitle Edit

Overview

Subtitle Edit is a free (open source) editor for video subtitles - a subtitle editor :)

With SE you can easily adjust a subtitle if it is out of sync with the video in several different ways. You can also use SE for making new subtitles from scratch (do use the time-line/waveform/spectrogram) or translating subtitles.

For a list of features see below or check out the Subtitle Edit Help page. On my blog you can download latest beta version and read about/discuss new features.

Also, you can watch a few videos about installing and using Subtitle Edit.

Transfer import facebook to vk

Coding

https://github.com/mekhovov/Export-Posts-from-FB-2-LI-VK/blob/master/export_FB_2_LI_VK.rb


Convert audio m4a to video

https://www.freeconvert.com/m4a-to-mp4/download DOESNT WORK ON YOUTUBE

RUSSIAN SITE https://online-audio-convert.com/ru/m4a-to-mp4/ DOESNT WORK ON YOUTUBE

kdenlive: crop a video

  • kdenlive crop a video
    • Click the zone start icon
    • Click he zone end icon
    • Right click the new zone and extract video

File:Kdenlive extract zone crop right click.png

merge 2 videos online

Adobe

https://express.adobe.com/tools/merge-videos/#

Quotes background maker

Quotes background maker

Delete portions of a page for printing

  • Print Edit WE
    • To start editing the page:
      • click on the Print Edit WE button on the main toolbar, or
      • select Print Edit WE > Start Editing on the context menu.
    • A blue 'EDIT' (editing) badge will appear on the button.


wifi

WiFi Keeps Disconnecting on Windows 10? Here’s the Fix

Install a Bandwidth Monitor On Your Computer


What's system interrupts high CPU usage in Windows 10

Change Rename Batch Files and Folders in Windows

4 Ways to Batch Rename Files in Windows (USE POWERSHELL)

https://www.maketecheasier.com/batch-rename-files-in-windows/

Doesnt work:
https://stackoverflow.com/questions/22182409/replace-part-of-file-name-powershell

Rename files by matching partial name (power toys - doesnt work)

https://www.windowscentral.com/how-rename-multiple-files-bulk-windows-10


General:

6 Ways to Rename Files and Folders in Windows 10

https://www.howtogeek.com/665514/6-ways-to-rename-files-and-folders-in-windows-10/

How to set a default Folder View for all folders in Windows 11/10

How to set a default Folder View for all folders in Windows 11/10

  • Open File Explorer by using key combination Windows Key + E and navigate to the folder you want to use as a source for view layout settings.
  • Windows 10, navigate to the View tab in ribbon baron the top and change the settings per your wish. You can change the layout and choose the folder details to display, add extra panes, adjust column width, etc.
  • Once done with the changes, click Options to open the File Explorer Options, earlier called Folder Options. window.
  • Finally, navigate to View tab in Folder Options window.
  • Click/Tap on Apply to Folders button.\

Sections in a taskbar

  1. The Windows TaskBar
  2. The Start Button--Opens the menu.
  3. The Quick Launch bar--contains shortcuts to commonly used applications. ...
  4. The main Taskbar--displays icons for all open applications and files.
  5. The System Tray--contains the clock and icons for some of the programs running in the background.


Unpin a program on the taskbar

https://www.thewindowsclub.com/cant-unpin-or-remove-program-icons-from-windows-10-taskbar

QUICK LAUNCH open folder

[https://www.lifewire.com/add-quick-launch-toolbar-in-windows-10-5115231


Enter %APPDATA%\Microsoft\Internet Explorer\Quick Launch\ into the navigation field at the top of the window, and press Enter. Click Select Folder. You now have a quick launch toolbar on your taskbar. However, it's on the right side, and the original quick launch was on the left.Aug 4, 2021

How to Add the Quick Launch Toolbar in Windows 10 - Lifewire

show blue links instead of { HYPERLINK link } in a document Word

How to show blue links instead of { HYPERLINK link } in a document Word

https://www.officetooltips.com/word_2016/tips/how_to_show_blue_links_instead_of___hyperlink_link___in_a_document_word.html

To change a representation of hyperlinks in a document, do the following:

1. On the File tab, click the Options button:

Options in Word 2016

2. In the Word Options dialog box,

  • on the Advanced tab,
  • under Show document content,
  • uncheck the Show field codes instead of their values checkbox:

Advanced tab in Word Options 2016 After clicking OK, all hyperlinks in the document will be shown as usual, as blue hyperlinks:

Hyperlink in Word 2016


MICROSOFT WORD - get hyperlinks to show
File>Options>Advanced> [Show document content] section uncheck the box for "Show field codes instead of their values".

YOUTUBE Add more channels to YouTube

Can You Have More Than One YouTube Channel? (January 21, 2021)

Visit your list of Channels, https://www.youtube.com/account

Click Create a new channel button.

Create a new channel button on YouTube

Give your new account a name, and then click Create.

New Brand Channel Create button on YouTube You'll immediately be taken to your new channel where you can customize your account and upload videos.

Screenshot program for laptop

LIGHTSHOT The fastest way to take a customizable screenshot

HOW TO GET FILE NAMES FOR ALL FILES IN A FOLDER

If the folder you want to open in Command Prompt is on your desktop or already open in File Explorer, you can quickly change to that directory.

Type cd followed by a space, DRAG AND DROP the folder into the window, and then press Enter. The directory you switched to will be reflected in the command line.

https://www.howtogeek.com/659411/how-to-change-directories-in-command-prompt-on-windows-10/#:~:text=If%20the%20folder%20you%20want,reflected%20in%20the%20command%20line.

INSTRUCTIONS:

0. Open Command Prompt

02: Copy and paste directory C:\Users\user\Desktop\STUFF


1. Type cd followed by a space,

2. drag and drop the folder into the window, and then

3. press Enter.

The directory you switched to will be reflected in the command line.

How to copy a list of file names in a folder to text file?

EXCELLENT!

use cmd.exe

type dir /b > dirlist.txt

SSL certificate

Free SSL certificate: https://app.zerossl.com/

Recording voice "on the fly"

Recording voice "on the fly": https://www.vocaroo.com


To sort

Bulk Resize photos

Youtube alternative

free video editors list

File:Unpin from task bar remove icon from taskbar.png

Microsoft Advanced Find and replace

Breaking a Document Link

Quotes background maker


SMS FOR CHEAP

Compare the Top Cloud Storage Services with a Free Trial of 2021

Download books (for free)

Convert audio to text

Convert video to audio

Skype shortcuts

Hang up Ctrl+Shift+H
Ctrl+Tab Next Conversation
Ctrl+Shift+Tab Previous Conversation
Alt+2 Open contacts
Ctrl+Shift+P Start an audio call
Hang up Ctrl+Shift+H

' https://www.autohotkey.com/ '

Google translate extension for Firefox browser, you can translate Yandex.ru also (Which you cannot do with google translate app on chrome):

https://addons.mozilla.org/en-US/firefox/addon/traduzir-paginas-web

Auto dialers * Archive.org * App - Call Recorder * Calendar * Chrome * Epson Printer and scanner * Translator * https://www.onlinedoctranslator.com/en/ TRANSLATE DOCUMENTS

Facebook * Google * Galaxy * Instagram * Mediawiki * including extensions

Combine merge stitch images * Free screenshot tools for windows 10 * Photoshop

Microsoft Office * Outlook * Microsoft Windows * Notepad

Namecheap * PDF * Programs/delete * Rename programs

Video * Video record screen * wifi * Flickr uploader * How to Track Sent Invitations on LinkedIn

10 Free Tools To Save or Print a List of File and Folder Contents

Samsung Galaxy phones

How do I move music, images, videos and other media to the SD card in my Galaxy device? * Backing up my Samsung device * How to Easily Backup Everything from Samsung Galaxy S9 to SD Card

WhatsApp

WhatsApp * How to Log In to Two WhatsApp Accounts at Once

Telegram

https://www.alphr.com/how-to-find-groups-in-telegram/ How To Find Groups In Telegram

https://bugs.telegram.org/c/112 spambot


Wordpress * Blog blogging

ABBYY Finereader

  • YOUTUBE

Youtube (includes editing videos) - AUDIO FILES

Russian alternatives to youtube

Merge stick photos online * flip photo for Zoom

timer * zoom lighting for animated video background zoom search

FTP client WinSCP

Create video

https://itsfoss.com/open-source-video-editors/

Edit videos

e


Microsoft Finding and replacing characters using wildcards

  1. https://wordmvp.com/FAQs/General/UsingWildcards.htm
  2. https://www.officetooltips.com/word_2016/tips/using_wildcards.html
  3. http://www.gmayor.com/replace_using_wildcards.htm

YouTube find and replace time stamps:

^13[0-9]{1}\:[0-9]{1,2}^13

How to Add Built-in Fields in Microsoft Word

https://www.msofficeforums.com/microsoft-word/ - Forum

Good afternoon!

I have an address template sheet I want to print (Avery 5160), I want to plugin names from a database of names.

So I would have the generic address on line two and three:

...

And then I would the name of the person on line one:

---

MOVE! ADOBE PDF

Program that works Adobe PDF: https://thepiratebay.org/torrent/5089141/Adobe_Acrobat_9_Pro_Extended_[ResourceRG]_Multi_Crack



Word

Quick Access Toolbar not working, all greyed out

https://answers.microsoft.com/en-us/msoffice/forum/all/quick-access-toolbar-not-working-all-greyed-out/af5a29f6-ce0e-481d-9d86-5b9f58f88f7b

Install pirate version

  • MICROSOFT Office PRO Plus 2016 v16.0.4266.1003 RTM + Activator [TechTools.NET]

Instructions:
1) Stop the application if started
2) Install application using provided installer and do not reboot
3) Run patch file
DONE!


www.Techtools.net / www.ThumperDC.com

Trouble shooting

Pop up window

[Window Title]


[Content]


Operation did not complete successfully because the file contains a virus or potentially unwanted software.


[OK]

Wildcards

http://www.gmayor.com/replace_using_wildcards.htm

CREATE TABLE OF CONTENTS Index - create and update an index

https://support.office.com/en-us/article/create-and-update-an-index-cc502c71-a605-41fd-9a02-cda9d14bf073

How to print without comments and track changes

File:Word no markup print.png

Word 2013 – How to print without comments and track changes

By default the comments and track changes mark-up will be printed. The get around this you need to hide all the changes from the screen. If you cannot see them on the screen they will not print.

sharepoint

How to create an HTML button that acts like a link?

<form action="http://google.com">
<input type="submit" value="Go to Google" />
</form>


How to set text color in submit button?

<input type="submit" style="font-face: 'Comic Sans MS'; font-size: larger; color: teal; background-color: #FFFFC0; border: 3pt ridge lightgrey" value=" Send Me! ">


​<input type="button" value="Go to Google" style="font-size: larger; color: white; background-color: #419bab; border: 1pt ridge lightgrey;"/>
Works
<div class="Button" style="background-color: #419bab; text-align: center;">​​​​​​​​ 
                  <a class="ButtonLink" href="/Registrar/"><font color="white" size="3">Registrar</font>​</a>​​​​​​​<br/></div>​​
<div class="Button" style="background-color: #419bab; text-align: center; width: 300px; height: 100px;">​<span class="ms-rteForeColor-2">​​</span>​​​​​​​​​​​​​ 
                  <a class="ButtonLink" href="/nursingeducationservices/Shared%20Documents/Associate%20Degree%20Nursing%20Program%20(ADNP)"><font color="white" size="3">Associate Degree Nursing Program (ADNP)​</font>​​​​​​​​​​</a>​​​​​​​<br/></div>​​<br/></td>
doesn't work
<div class="Button">
   <p>​​<br/></p>
   <p>​​<br/></p> 
   <input type="button" value="Go to Google" style="font-size: larger; color: white; background-color: #419bab; border: 1pt ridge lightgrey;"/>​​ ​ ​ ​ 
   <p>​​<br/></p>​ 
   <p>​​<br/></p>
</div>


Wildcards

Find and Replace using wildcards

This tutorial pre-supposes that the user will have some basic experience of Word's 'replace' function.

The secret of using wildcard searches is to identify the unique string of text that you wish to find. Wildcards are combined with regular text and formatting options to represent the characters or sequences of characters in that string. Because different combinations of characters can be represented by a variety of wildcard combinations, there is often more than one way of identifying a particular string of text within a document. How you choose to represent that group of characters is therefore a matter of individual preference; and the context of the text within the document will to a great extent dictate the most suitable combination to use on a particular occasion.

Wildcard searches are case sensitive.

Start by identifying the string you wish to replace and then pop up the replace function (CTRL+H) or select Advanced Find from the Editing group on the Home tab of the ribbon (see below); or in earlier Word versions Edit > Replace.

Click the 'More' button to present the additional functions and check the 'Use wildcards' option:

With the cursor in the 'Find what:' or 'Replace with:' boxes you can use keyboard shortcuts to enhance the strings with the principle formatting options e.g CTRL+U - underline, CTRL+I - italics, etc. These operate as toggles to cycle through the various options available.

Insert your find and replace strings using the following guide for inspiration. Wildcard Description Notes

? and * The two most basic wildcards are ? and *.

They are essentially similar in use.

? is used to represent a single character and * represents any number of characters. On their own, these have limited use.

s?t will find sat, set,sit ,sot and any other combination of three characters beginning with 's' and ending with 't'. It will also find that combination of letters with a word, thus it would locate the relevant (highlighted) part of inset etc. In the quoted example, the asterisk returns st as a match.

Word does not limit the number of characters that the asterisk can match, and it does not require that characters or spaces reside between the literal characters that you use with the asterisk.

The asterisk is a rather blunt weapon which must be used with care, as it can return a lot of unwanted results.

@ @ is used to find re-occurrences of the previous character (if any). e.g. lo@t will find lot or loot, ful@ will find ful or full etc.

< > With any of the above (or any other combination of wildcards and characters), you can use the brackets < and > to mark the start and end of a word respectively. Thus in the example used above for '*'

<s*t> would find 'secret' and 'serpent', but not 'sailing boats' and 'sign over documents'. Though again, given the use of '*', beware as it will find the block of text from a word starting with 's' to the end of the next word in the document ending with 't', e.g. 'sailing boat' which may not be what you had in mind.

The <> brackets can be used in pairs as above or individually as appropriate e.g. ful@> will find 'full' and the appropriate part of 'wilful' but not 'wilfully

[ ] Square brackets are always used in pairs and are used to identify specific characters or ranges of characters. e.g.:

[abc] will find any of the letters abc. [F] will find upper case 'F';

[A-Z] will find any upper case letter; [0-9] will find any single number; [13579] will find any odd numbers; [0-9A-Za-z] will find any numbers or letters.

The characters can be any character or series of characters, including space. Characters are processed in order - lowest first. If you are uncertain which character is lower than another check with 'Insert > Symbol'.

[!] [!] is very similar to [ ] except in this case it finds any character not listed in the box so [!o] would find every character except “o”.

You can use ranges of characters in exactly the same was as with [ ], thus [!A-Z] will find everything except upper case letters.

For advanced users only

You can paste any (Unicode) character - unfortunately *not* characters from decorative (Symbol) fonts) - into your search expressions. So copying the first and last characters from the Greek or cyrillic subsets into a search:

[;-ώ] would match any Greek character α β γ δ ε ...

<[Ё-ґ]@> matches any cyrillic word: Вы можете помочь мне? (“Can you help me please?”)

In Word 2000, you can type in Unicode characters with the Alt-key (make sure NumLock is on, then hold down the Alt-key and type the numbers on the numeric keyboard). Since all characters from decorative fonts (Symbol-, Wingdings-fonts ...) are kept in a special code page from &HF000 to &HF0FF, you can search for them with [Alt61472-Alt61695].

{ } Curly brackets are used for counting occurrences of the previous character or expression.

{n} This finds exactly the number 'n' of occurrences

             of the previous character

{n,} Finds at least the number 'n' occurrences. {n,m} Finds the number of occurrences from 'n' to 'm'.

Note: The above examples employ a comma as a list separator {n,m} - for languages that use alternative list separators, substitute the local separator character (often a semi-colon {n;m}) as appropriate. Counting can be used with individual characters or more usefully with sets of characters e.g. [deno]{4} will match done, node, eden) or bracketed groups: (ts, ){3} will match ts, ts, ts, .

(Unfortunately, there is no wildcard to search for "zero or more occurrences" in Word wildcard searches; [!^13]{0,} does not work).

( ) Round brackets have no effect on the search pattern, but are used to divide the pattern into logical sequences, where you wish to re-assemble those sequences in a different order during the replace - or to replace only part of that sequence. They must be used in pairs.

The partnering backslash character is used as a replacement string in conjunction with a number to indicate which pair of brackets numbered from the left is required e.g.

(John) (Smith) replaced by \2 \1 - note the spaces in the search and replace strings - will produce Smith John

or replaced by \2 alone will give Smith. The placeholders \1, \2 etc., can also be used in the search string to identify recurring text. e.g.

Fred Fred could be written (Fred) \1.

\ If you wish to search for a character that has a special meaning in wildcard searches - the obvious example being '?'. then you can do so by putting a backslash in front of it: [\?] will find the question mark character '?'

If you wish to find the backslash itself then you need to precede that with a backslash [\\].

The following is a list of the characters that have a special meaning in wildcard searches ( [ ] { } < > ( ) - @ ? ! * \ ) See also 'Gremlins to be aware of (for advanced users only)' at the end of this page

Gotchas .

You may wish to identify a character string by means of a paragraph mark ¶. The normal search string for this would be ^p.

^p DOES NOT WORK in wildcard search strings! It must however be used in replacement strings, but when searching, you must look for the substitute code ^13.

Wildcard searches will also not find footnote/endnote marks - substitute ^2.

A-z would be expected to reproduce all the letters between A and z i.e. both upper case and lower case letters, which it does, but it reproduces all the characters from ASCII 65 to ASCII 122, and that block also includes the characters [ ] ` ^ _ / Use A-Za-z instead.

The question mark ? is used to find individual characters. If used with curly brackets to define a range of characters eg

  1. ?{1,3}# it will behave as an asterisk and find all the characters between the hash symbols.

Control Codes that may be used with the search/replace tool Code Notes

^1 In-line picture

^2 Auto referenced footnotes

^5 Annotation mark

^9 Tab

^11 New line

^12 Page or Section break

^13 Paragraph break / 'carriage' return

^14 Column break

^19 Opening field brace (when field braces are visible)

^21 Closing field brace (when field braces are visible)

? Question mark

^? Any single character (not valid in the Replace box)

^- Optional hyphen

^~ Non-breaking hyphen

^^ Caret character

^# Any digit

^$ Any letter

^& Contents of 'Find What' box (Replace box only)

^+ Em dash (not valid in the Replace box)

^= En dash (not valid in the Replace box)

^u8195 Em Space Unicode character value search (not valid in the Replace box)

^u8194 En Space Unicode character value search (not valid in the Replace box)

^a Comment (not valid in the replace box) (Word 97-2000 only)

^b Section break (not valid in the replace box)

^c Replace with Clipboard contents (Replace box only)

^d Field

^e Endnote Mark (not valid in the Replace box)

^f Footnote Mark (not valid in the Replace box)

^g Graphic (In Line Graphics Only). In Word 2007 a forward slash / also appears to find in-line graphics. This appears to be an unintentional bug.

^l New line -

^m Manual Page Break

^n Column break

^t Tab -

^p Paragraph Mark -

^s Non-breaking space

^w White space (space, non-breaking space, tab); not valid in the Replace box

^nnn Where "n" is an ASCII character number

Note: ASCII codes below 128 were standardized a long time ago, before the introduction of Windows operating systems. The upper codes were used for OS-specific, localized, or vendor-specific stuff. When DOS code pages were replaced by Windows code pages, a leading zero was used to indicated the difference. Thus ^32 and ^032 will both represent a space character, but ^147 will represent ô and ^0147 will represent “

^0nnn See above (Produces ASCII on Macintosh).

^unnnn Unicode character search where "n" is a decimal number corresponding to the Unicode character value. Note: Instructions on how to identify the required decimal number are included at the end of this page.

Note: To search for a specific field, such as an XE (Index Entry) field, use the following syntax: ^19 field name

Putting it into practice

Example 1.

There are many occasions when you are presented with blocks of text or numbers etc., where the order of the text is not what you might require in the final document. Swapping the placement of forename and surname as above is one such example - and don't forget you can add to the replacement, even when using bracketed replacements

e.g. you may wish John Smith to appear as Smith, John or, more likely, you may have a column of names in a table, where you wish to exchange all the surnames with all the forenames.

You could do them one at a time, but by replacing the names with wildcards, you can do the lot in one pass.

Let's then break up the names into logical sequences that can only represent the names.

At its simplest, we have here two words - John and Smith. They can be represented by <*>[space]<*> - where [space] is a single press of the spacebar.

Add the round brackets (<*>)[space](<*>) and replace with \2[space]\1

Run the search on the column of names and all are swapped. Run it again and they are swapped back.

If you get it wrong, remember that Word's 'undo' function (CTRL+Z) is very powerful and has a long memory!

Example 2

This could be the changing of UK format dates to US format dates - or vice versa.

7th August 2001 to August 7th, 2001

To give an example of how most of the wildcards could be used in one search sequence to find any UK date formatted above to its equivalent US format date, the following search pattern will do the trick:

[0-9]{1,2}[dhnrst]{2} <[AFJMNSOD]*>[0-9]{4}

Breaking it down [0-9] looks for any single digit number, but dates can have two numbers so to restrict that to two, we use the count function. We want to find dates with 1 or 2 numbers so

[0-9]{1,2}

Next bit is the ordinal 'th'

- Ordinals will be 'st' 'rd' or 'th' so identify those letters specifically:

[dhnrst]

There will always be two letters, so restrict the count to 2

[dhnrst]{2}

Next comes the space. You can insert a space [space]

The month always begins with one of the following capital letters - AFJMNSOD. We don't know how many letters this month has so we can use the blanket '*' to represent the rest. And we are only interested in that word so we will tie it down with <> brackets.

<[AFJMNSOD]*>

there's another space [space] followed by the year. The years here have four numbers so

[0-9]{4}

Finally add the round brackets to provide a logical breakup of the sequence

([0-9]{1,2}[dhnrst]{2})[space](<[AFJMNSOD]*>)[space]([0-9]{4})

and replace with

\2[space]\1,[space]\3

to re-order the sequence.

Example 3

Assume you are parsing addresses and wish to separate the honorific from the name.

American usage puts a full stop (period) at the end ("Mr.", "Mrs.", "Dr.") while British usage often omits the full stop.

([DM][rs]{1,2})( )

will find Mr Mrs Dr

without the stop and

\1.\2

will put one in.

or vice versa

([DM][rs]{1,2}).

will find Mr. Mrs. Dr. with the stop and

\1

will take it out.

Further examples:

(*^13)\1\1 will match any sequence of three identical paragraphs,

(*^13)@ will match any number of replacement paragraphs. Replace with \1 to remove duplicates from a sorted list.

\<([!\<\>]@)\>[!\<\>]@\</\1\> will match any well-formed XML element including start-tag and end-tag

(“

some text

” or “<customer-name>John Smith</customer-name>”)

By creating logical sequences you can search for almost any combinations of characters.

Gremlins to be aware of (for advanced users only)

Sometimes Word will get confused if it encounters “escaped” brackets \( or \), for example “(\\)” will match *any* character, not only a backslash

Workaround: use "([" instead.

([a-z]\() throws an error - should find an "a(".

Workaround: Use ([a-z][\(]) instead.

Not a bug but still annoying: You have to escape any special character even if you type its code; so ^92 will have the same problems as typing the backslash.

The construction {0,} (find zero or more of the preceding item) is refused as incorrect syntax. This concept is available in Unix regular expression matching, so it's a curious omission.

You don’t always have to “escape” the special characters, if the context makes it clear that the special meaning isn’t wanted. [abc-] matches "-", and [)(] matches ")"

or "(". This may sometimes make your searches behave differently from what you expected.

Establish the unicode decimal number for a character

When searching for a symbol from the extended character set using its unicode decimal number i.e. ^unnnn you first need to identify that number.

First select the first example of the character (e.g. the Cyrillic character ю in the document, then activate the Insert > Symbol dialog.

The dialog opens with the character selected:

Note the Unicode (hex) character code number - here 044E.

Open the Windows calculator and change its view to the Programmer's calculator, ensure that the Hex radio button is checked and enter the number into the calculator.

In some earlier Windows versions, the calculator has a different layout. The 'hex' and 'dec' conversion buttons are in the Scientific calculator view.

Click the Dec radio button and note the changed number

You can then use the four digit number in conjunction with the ^unnn (^u1102) to find the characters in the document.

Macro to identify the four digit number indicated above

The following macro will identify and copy the value of the character at the cursor to the clipboard, for ease of pasting into the find and replace tool's 'Find what' dialog.

If you don't know how to use macro listings, see https://www.gmayor.com/installing_macro.htm.

Note that the following macro requires a reference to the Microsoft Forms 2 Object Library to be checked in the vba editor tools > references (see following illustration).