We’ve now looked at searching, and hopefully you’re finding your files easily. But how often are the ones that you’re looking for at the top of the results list? Let me share some advanced search techniques with you.
Wildcard symbols
How often have you remembered part of the filename, but not all of it?
There may be times when you can’t remember exactly how you’ve spelt something.
It’s at this time that the wildcard symbols are worth their weight in gold.
So, a wildcard symbol allows you to replace some or a specific number of characters that you’re not sure about.
There are a number of options available, but I have two favourites.
Question Mark (?)
The question mark is used to replace a single character in a specific place that you’re not sure about.
For example, you’ve got a client called ‘Reed’, but you can’t remember exactly how they spell their name.
- Reed
- Read
- Reid
When you look at these three possible spellings, they all start with ‘Re’ and end with ‘d’. It’s that third letter that we’re not sure about.
This is where the question mark comes in.
We can search on Re?d.
The results will come up with all three variations, as the question mark replaces a single character.
However, as it’s in that specific place, ‘Ried’ wouldn’t appear as it doesn’t start ‘re’.
If you’re wondering, can you use multiple question marks, then the answer is yes.
Remember each question mark replaces one character. It’s not too bad if you’ve got between, say 1 and 4 characters, but you don’t want to sit there typing a bunch of question marks in.
And that’s where the next option comes in handy.
Asterisk (*)
This single character – the asterisk – standards for any number of other characters.
Let’s take the same example of Reed.
Typing in Re*d, will come up with a lot more results.
Sure it will give Reed, Read and Reid.
However, it will also include Red – with no additional characters.
But also ‘Reconciled’, ‘Recorded’, and any other word you can think of that starts ‘Re’ and ends with ‘d’.
The asterisk is great when you just don’t know what might be missing.
Similar to the question mark, the position of the asterisk makes a difference to the search results.
*red
r*ed
Re*d
red*
There will be some similarities for all of these options, e.g. red, but also a number of differences.
With the asterisk at the beginning you’re searching for anything ending with ‘red’, for example:
- Multichambered
- Underprepared
- Transgendered
- Outmaneurered
- Considered
- Registered
Likewise, with the asterisk at the end, you’re looking for anything starting ‘red’, examples include:
- Redact
- Redberries
- Redeem
- Redefining
- Redesign
- Redirected
😁 definitely a bit different.
Hopefully you get the idea, without me having to list some examples of the other two options.
What’s great about the asterisk is that it can be used in a number of different ways.
For example, finding different file types (if you’re not sure what I’m talking about check out this blog Do you know your files types?).
Say you wrote a file called ‘The Importance of Being Earnest” (a play by Oscar Wilde, with two films that I’m aware of). But you can’t remember if it was a document or a presentation.
Your search would be the importance of being earnest.*
By using the asterisk after the full stop, you’re saying that you’re looking for any file type with that title.
OK – I get it, just typing in the title you’d get the same results.
How about this example, *tips.
Now you’ll get any files that end with ‘tips’.
- Computer Tips
- Word Tips
- Excel Tips
- Pinterest Tips
- Photography Tips
- Healthy Eating Tips
Maybe you’re looking for all of your pro files – so the search would be pro*.
Consider what you’re looking for and what you can remember, then use the asterisk to replace the ‘blank’.
Oh, and if you’re wondering if you can use multiple asterisks – yes and no.
Unlike the question mark, there’s no point in typing in multiple asterisks – pro***, as one symbol covers any number.
However, if you’re not sure where the order of the text it is, then type in *pro*.
This will search for pro, at the beginning, middle or end of the filename.
Double Quotes
How often have you wanted to search for all or part of a name, that’s more than one word?
You type the text in, and… you get all of the files that have any of those words in.
Really great when you’re using and, or, in, the, etc.
Here’s where the double quotes comes in.
The double quotes is like saying ‘all of these words needs to be included’.
It doesn’t matter where they are in the name, but they all have to be together.
Ah, and the other thing is that they have to be in this specific order.
For example, “in Windows”, will return:
- In windows, typing tips
- Shortcut keys in Windows
It won’t include:
- In your windows
- In your copy of windows
- In Microsoft Windows
As they aren’t an exact match to what you’re searching for.
Next Steps
That’s three advanced techniques to help you search for your specific filenames, when you can’t remember exactly what you called it.
Oh, and these advanced searching tips – well they work on most searches. Whether it’s for files or their contents, emails or of course, internet searching!
So, once again, it’s over to you. Search for something, today or tomorrow and see how these simple tips can improve the search results.
Other Posts about Computer Files
What do you need to know about computer files?
Do you really need file organisation?
What’s so great about online file storage
Why sharing is better than attaching
Are you searching your files to save time?
Improve your results with these advanced search techniques (current post)
Related Product
File Management Foundations: Simplify, Share and Search
Managing your files well is one of those things that makes everything else easier. This plain-English guide covers the essentials — how to organise, store, share, and search your files — so you spend less time hunting and more time actually getting things done.
Recent Posts
- The Fastest Way to Copy Formatting in Word
If you’ve ever spent time getting text looking exactly right in Word, only to realise you need to apply the same formatting somewhere else, you’ll know how tedious it is to redo every single click. The good news is that copying formatting in Word is much easier than you might think — and Format Painter… Read more: The Fastest Way to Copy Formatting in Word - Microsoft Word’s Overlooked Reading Views: Less Clutter, More Focus
If you’ve ever opened a Word document and felt slightly overwhelmed by everything on screen, you’re not alone. The good news is that these overlooked Word views exist precisely for moments like that — and most people have never even clicked on it. There’s also a Focus View that takes things a step further. Let… Read more: Microsoft Word’s Overlooked Reading Views: Less Clutter, More Focus - Why Your Colour-Coded Excel Data Deserves a Better Filter
If you’re already using colour to organise your Excel spreadsheets, here’s some good news — you can filter by that colour too. Excel filter by colour lets you instantly show only the rows that match a specific colour — whether that’s a background fill or a font colour. It’s one of those features that feels… Read more: Why Your Colour-Coded Excel Data Deserves a Better Filter - Excel Paste Values – Get Exactly What You See, Every Time
If you’ve ever copied something in Excel and ended up with a completely different result than you expected, you’ve probably fallen foul of one of Excel’s little quirks. The good news is that once you understand Excel Paste Values, you’ll know exactly how to handle it – and it only takes a couple of extra… Read more: Excel Paste Values – Get Exactly What You See, Every Time - Excel Sparklines: The Tiny Charts Making a Big Difference
If you’ve ever stared at a column of numbers and thought “I just want to see the pattern” — Excel Sparklines are about to become your new favourite thing. These miniature charts sit inside a single cell, right next to your data, giving you an instant visual snapshot without the faff of building a full… Read more: Excel Sparklines: The Tiny Charts Making a Big Difference
using advanced search operators, advanced search techniques, mastering file searches