Highlight duplicate words.. ?? IN MICROSOFT WORD !!

Abhirockie

Board Regular
Joined
Jan 18, 2016
Messages
73
This is Related to WORD DOCUMENT ..

I have below WORD DOCUMENT. With repeated words OR duplicates. I want to find and Highlight repeated words with RED COLOR AT one time. Can I do that??

I want to highlight DOG with some color. Please help me how to do it??

Apple Ball Cat Dog Egg Gun Fish Hat Ink Jam Dog Egg Gun Fish Hat Ink Jam Dog Egg Gun Fish Hat Ink Jam Dog Egg Gun Fish Hat Ink Jam Cat Dog Egg Gun Fish Hat Ink Cat Dog Egg Gun Fish Hat Ink Cat Dog Egg Gun Fish Hat Ink Cat Dog Egg Gun Fish Hat Ink Cat Dog Egg Gun Fish Hat Ink Cat Dog Egg Gun Fish Hat Ink Cat Dog Egg Gun Fish Hat Ink Cat Dog Egg Gun Fish Hat Ink Dog Egg Gun Fish Hat Ink Jam Cat Dog Egg Gun Fish Hat Ink Cat Dog Egg Gun Fish Hat Ink Cat Dog Egg Gun Fish Hat Ink Cat Dog Egg Gun Fish Hat Ink Dog Egg Gun Fish Hat Ink Jam Cat Dog Egg Gun Fish Hat Ink Dog Egg Gun Fish Hat Ink Jam Cat Dog Egg Gun Fish Hat Ink Dog Egg Gun Fish Hat Ink Jam
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
You could use Find/Replace to Find the word you're looking for and Replace it with the same word highlighted. All done via the Find/Replace dialogue.
 
Upvote 0
Nope its not working. When you copy the text heighlighted, it is taking as normal text and not copying highlighted.

you could use find/replace to find the word you're looking for and replace it with the same word highlighted. All done via the find/replace dialogue.
 
Upvote 0
This is a fairly standard use of Find/Replace. For example, to highlight all instances of 'Ball' in your text string, you could set:
Find = Ball
Replace = ^&
and for the Replacement choose Format>Highlight. To use different highlights for different words, use Word's highlight tool to change the default highlight colour. It couldn't be much simpler.
 
Upvote 0
It doest really solve my issue. I have the data of 200 pages with same content and with your answer i have to highlight word by word. But i wanted to highlight all at one time.

Can some1 help me on this ???



This is a fairly standard use of Find/Replace. For example, to highlight all instances of 'Ball' in your text string, you could set:
Find = Ball
Replace = ^&
and for the Replacement choose Format>Highlight. To use different highlights for different words, use Word's highlight tool to change the default highlight colour. It couldn't be much simpler.
 
Upvote 0
So you really want every instance of words like:
a, all, also, although, always, among, and, another, any, around, as, ask, at, away
highlighted if they appear more than once in a 600-page document???? And that's just words beginning with 'a'! If not, you need to be a whole lot clearer about your expectations.
 
Upvote 0
Paul,

My Question Is simple and straight. I have a huge document with repeated words/Duplicates. I want to high-light a single repeated word with "RED COLOR" At 1 shot.
 
Upvote 0
My Question Is simple and straight.
Indeed, it's so simple it's meaningless. Your example has no repeated/duplicated words (e.g. BALL BALL); it merely has words that mostly appear more than once, sometimes in the same sequence as other words.
 
Upvote 0
Please ignore Above message. I am writing a new question.

I have below document I wanted to highlight DOG with some color. If you have any fast/speed solution. please do let me know ??


Apple Ball Cat Dog Egg Gun Fish Hat Ink Jam Dog Egg Gun Fish Hat Ink Jam Dog Egg Gun Fish Hat Ink Jam Dog Egg Gun Fish Hat Ink Jam Cat Dog Egg Gun Fish Hat Ink Cat Dog Egg Gun Fish Hat Ink Cat Dog Egg Gun Fish Hat Ink Cat Dog Egg Gun Fish Hat Ink Cat Dog Egg Gun Fish Hat Ink Cat Dog Egg Gun Fish Hat Ink Cat Dog Egg Gun Fish Hat Ink Cat Dog Egg Gun Fish Hat Ink Dog Egg Gun Fish Hat Ink Jam Cat Dog Egg Gun Fish Hat Ink Cat Dog Egg Gun Fish Hat Ink Cat Dog Egg Gun Fish Hat Ink Cat Dog Egg Gun Fish Hat Ink Dog Egg Gun Fish Hat Ink Jam Cat Dog Egg Gun Fish Hat Ink Dog Egg Gun Fish Hat Ink Jam Cat Dog Egg Gun Fish Hat Ink Dog Egg Gun Fish Hat Ink Jam Apple Ball Cat Dog Egg Gun Fish Hat Ink Jam Dog Egg Gun Fish Hat Ink Jam Dog Egg Gun Fish Hat Ink Jam Dog Egg Gun Fish Hat Ink Jam Cat Dog Egg Gun Fish Hat Ink Cat Dog Egg Gun Fish Hat Ink Cat Dog Egg Gun Fish Hat Ink Cat Dog Egg Gun Fish Hat Ink Cat Dog Egg Gun Fish Hat Ink Cat Dog Egg Gun Fish Hat Ink Cat Dog Egg Gun Fish Hat Ink Cat Dog Egg Gun Fish Hat Ink Dog Egg Gun Fish Hat Ink Jam Cat Dog Egg Gun Fish Hat Ink Cat Dog Egg Gun Fish Hat Ink Cat Dog Egg Gun Fish Hat Ink Cat Dog Egg Gun Fish Hat Ink Dog Egg Gun Fish Hat Ink Jam Cat Dog Egg Gun Fish Hat Ink Dog Egg Gun Fish Hat Ink Jam Cat Dog Egg Gun Fish Hat Ink Dog Egg Gun Fish Hat Ink Jam Apple Ball Cat Dog Egg Gun Fish Hat Ink Jam Dog Egg Gun Fish Hat Ink Jam Dog Egg Gun Fish Hat Ink Jam Dog Egg Gun Fish Hat Ink Jam Cat Dog Egg Gun Fish Hat Ink Cat Dog Egg Gun Fish Hat Ink Cat Dog Egg Gun Fish Hat Ink Cat Dog Egg Gun Fish Hat Ink Cat Dog Egg Gun Fish Hat Ink Cat Dog Egg Gun Fish Hat Ink Cat Dog Egg Gun Fish Hat Ink Cat Dog Egg Gun Fish Hat Ink Dog Egg Gun Fish Hat Ink Jam Cat Dog Egg Gun Fish Hat Ink Cat Dog Egg Gun Fish Hat Ink Cat Dog Egg Gun Fish Hat Ink Cat Dog Egg Gun Fish Hat Ink Dog Egg Gun Fish Hat Ink Jam Cat Dog Egg Gun Fish Hat Ink Dog Egg Gun Fish Hat Ink Jam Cat Dog Egg Gun Fish Hat Ink Dog Egg Gun Fish Hat Ink Jam Apple Ball Cat Dog Egg Gun Fish Hat Ink Jam Dog Egg Gun Fish Hat Ink Jam Dog Egg Gun Fish Hat Ink Jam Dog Egg Gun Fish Hat Ink Jam Cat Dog Egg Gun Fish Hat Ink Cat Dog Egg Gun Fish Hat Ink Cat Dog Egg Gun Fish Hat Ink Cat Dog Egg Gun Fish Hat Ink Cat Dog Egg Gun Fish Hat Ink Cat Dog Egg Gun Fish Hat Ink Cat Dog Egg Gun Fish Hat Ink Cat Dog Egg Gun Fish Hat Ink Dog Egg Gun Fish Hat Ink Jam Cat Dog Egg Gun Fish Hat Ink Cat Dog Egg Gun Fish Hat Ink Cat Dog Egg Gun Fish Hat Ink Cat Dog Egg Gun Fish Hat Ink Dog Egg Gun Fish Hat Ink Jam Cat Dog Egg Gun Fish Hat Ink Dog Egg Gun Fish Hat Ink Jam Cat Dog Egg Gun Fish Hat Ink Dog Egg Gun Fish Hat Ink Jam
 
Upvote 0

Forum statistics

Threads
1,214,819
Messages
6,121,739
Members
449,050
Latest member
excelknuckles

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top