Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: newb- Search/Replace wildcard question ...?

09 Jun 2011   #1

newb- Search/Replace wildcard question ...?

In search and replace in MS Word, or Excel, how do I replace this:


with this:


ie: simply search for a number within parenthesis and make it italicized?

Or maybe a macro?
An example of a cell would be
1:22:01 to 1:23:01  (415e)  duration 1

My System SpecsSystem Spec
09 Jun 2011   #2

Windows 7 Ultimate SP1 64-Bit

Hit F5 to bring up this dialog box.

newb- Search/Replace wildcard question ...?-f5.png

Select the Replace tab.

Type (315) in the Find What field.

Hit Ctrl+I to invoke Italics formatting and type (315) in the Replace With field (Note the format annotated under Replace With).

Click Replace All followed by OK.

My System SpecsSystem Spec
09 Jun 2011   #3


thanks for your reply seavixen.

that works in MS Word I think.
But I tried it just now in Excel and it didn't work.
The searches work differently in Excel and Word it looks like.

Can you make it work for EXCEL?
My System SpecsSystem Spec

09 Jun 2011   #4

Windows 7 Ultimate SP1 64-Bit

Yes, it is different.

newb- Search/Replace wildcard question ...?-excel-replace.png

Not sure which version of Excel you're using, but I'm using 2010.

Click Find & Select at the far right of the ribbon on the Home tab.

Select Replace & Options then choose your format.

My System SpecsSystem Spec
10 Jun 2011   #5


Excellent help seavixen32! I thought I was pretty savvy about Find and Replace, but you opened my eyes to a lot of customizations possible.
Rep+ to you.

And for other posters, here's some additional info that I just discovered:

To replace regular fonts with ANY FONT STYLE you want (e.g. new font, font size, bold/not bold, italics/no italics, etc.):
In a Word doc, open Find + Replace. Select the Replace tab.
Type the desired text in the ‘Find What’ field.
In the ‘Replace With’ field, type the desired text.
Then, with the cursor still inside the ‘Replace With’ box, at the bottom-left of the Find + Replace screen, select Format, then Font, and then you can then select any font changes you wish.
My System SpecsSystem Spec
10 Jun 2011   #6

Windows 7 Ultimate SP1 64-Bit

Thank you very much for your kind comments. Obviously, when people take time out to add to my reputation it is very much appreciated, but like many more on WSF, I take great pleasure in knowing I've helped someone.
My System SpecsSystem Spec

 newb- Search/Replace wildcard question ...?

Thread Tools

Similar help and support threads
Thread Forum
Wildcard Search "lazy search" and "greedy search"
How do I search on "<#EEEE#>" and select only the "EEEE". I'm a teacher and I use styles to include quiz answers in a document. I then change the font size to "1", or to "hidden". I review the answers in class using a projector, and I want to reveal the answers one at a time. A properly...
Newb, Win 7 Batch file question-KVM switching
hello Sorry if I'm posting this to the wrong place, but I'm not sure what this would be classed under. I would like to be able to change between the two computers connected to my KVM by clicking on an icon. My Belkin KVM has a remote switch that should be on my desktop, but my two cats...
General Discussion
Need XP-style search program to replace the Windows Seven search
I will only buy one, if I have no choice, but I do not feel that I should have to in order to replace something that came with Windows 7 and should have worked in the first place. Everything is not anything close to the search interface that was in Windows XP. I tried Google. All of the...
search and replace in file name
I'm trying to shorten up some too-long file path names. I have some recurring strings that I could just delete, but for the life of me I can't find any search & Replace function for file names. Is there a way?
General Discussion
newb question of the day. Windows Media Player
Ok, so i run Windows Media Player all day. the times i go to put in a disc to burn or erase or whatever the case may be Media Player stops and a pop-up will display the contents of the disc. Is there anyway to turn this off so this doesnt happen. Ive gone through the drive settings and that didnt...
Media Center
eSata Newb Question
Hi, there My HP lappy (vista) has an eSata port on the side and so tonight I bought an eSata card for my custom build (win7). Plugged it in etc, it automagically installed the drivers. I then connected the eSata cable into the back of the custom build and then into my lappy. From there I'm...
Hardware & Devices

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 13:52.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App