Over 1 million tech questions and answers.

Word Document find and replace, find duplicates

Q: Word Document find and replace, find duplicates

I have a document that is hundreds of pages long.

Within this document there are certain sentences, phrases that repeat and I need to find them in a practical manner.

Now I could go through manually, look for lines I suspect are repeated elsewhere and search for them, but that would take forever.

Is there any practical way to do this with Word 2010, Windows 7 Index or some other piece of software?

RELEVANCY SCORE 200
Preferred Solution: Word Document find and replace, find duplicates

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Word Document find and replace, find duplicates

Hello qochi, welcome to the forum.

Lots of information here to use in 'Search and Find' :
Find and replace text by using regular expressions (Advanced) - Word - Office.com
One simple word of advice - before proceeding, please save a copy of your document.

Please post back to let us know if that fits your needs.

Read other 3 answers
RELEVANCY SCORE 88.4

Here's what I am trying to do. I have tried some wildcards but i really have no idea how to make this work.

DD_ZS_001 - http://websitesname.com/download1
DD_ZS_002 - http://http://websitesname.com/download2
DD_ZS_003 - http://http://websitesname.com/download3
and so on (there are many links)

I want to take out DD_ZS_001 - in front of every link to have just download link link this:
http://websitesname.com/download1

Note that strings before the link are all different so I cannot use same find and replace in word or notepad.

I don't have access to bsd or linux box. Windows only.

Any help is appreciated.
 

A:Find and replace in word - need help

When you open your Find and Replace click on More button ,select use Wildcards , Enter DD_ZS_???- and it will remove all instances. The number of question marks depends on the size of the number 3 numbers 3 ???
 

Read other 2 answers
RELEVANCY SCORE 88.4

I saved a Word document in documents folder. I can't see the document in the folder nor in the search. When I save a new document with the same name, I get a message 'File already exist'. I tried using the 'Show hidden files and folders' option, but I still don't see the Word document.

Please help.

Read other answers
RELEVANCY SCORE 88.4

When using word and going to edit, find to locate a word, the whole screen is taken over by find, and it appears to be searching for the word but you can not see the document, is there a setting that needs to be change on this?, Also when you hit cancel it finds the word, But while using the Find option you cant see the document at all. Any suggestions?
 

A:MS Word, Using Edit-Find, can't see document

Better run Word troubleshooting: www.theofficeexperts.com/word.htm
 

Read other 1 answers
RELEVANCY SCORE 87.6

I have written a macro in MS Word that basically checks items off a list. It is based off of the seach and replace function, all it does is serach for a term and when it finds it changes it's color to blue and makes it strikethrough. I don't know if this is the most efficient way of doing it but this is the way I've come up with.

What I would like to add to it is the ability to have it tell me when the term is not found in the list, and possibly add it to the bottom of the list in a red color or something. Anyone know how I could do that?

Here is the macro code:
Sub CrossOff()

For x = 1 To 5 'Find and replace 5 times

SearchTerm = InputBox("Word to search")

Selection.Find.ClearFormatting
Selection.Find.Replacement.ClearFormatting

With Selection.Find
.Text = SearchTerm 'Word to search for
.Replacement.Text = SearchTerm 'Replace with same word, different formatting
End With

'Selection.Find.Replacement.ClearFormatting

With Selection.Find.Replacement
.Text = SearchTerm
.Font.Color = wdColorBlue 'change the text to blue
.Font.StrikeThrough = True 'cross it out
End With

Selection.Find.Execute Replace:=wdReplaceAll

Next x

End Sub
 

Read other answers
RELEVANCY SCORE 87.6

I want to create a customised 'find and replace' function that
uses a userForm similar to the word find and replace dialog box
but with the following Extras:

option radio buttons 'Left', 'Right', 'Both'
so for example if the 'left' radio button was checked and the
text to be replaced is '#' then all the text left to the '#'
including the '#' on the same line would be replaced.

Hope this is clear.

Thanks in advance.
 

Read other answers
RELEVANCY SCORE 87.6

I have written a macro in MS Word that basically checks items off a list. It is based off of the seach and replace function, all it does is serach for a term and when it finds it changes it's color to blue and makes it strikethrough. I don't know if this is the most efficient way of doing it but this is the way I've come up with.

What I would like to add to it is the ability to have it tell me when the term is not found in the list, and possibly add it to the bottom of the list in a red color or something. Anyone know how I could do that?

Here is the macro code:
Sub CrossOff()

For x = 1 To 5 'Find and replace 5 times

SearchTerm = InputBox("Word to search")

Selection.Find.ClearFormatting
Selection.Find.Replacement.ClearFormatting

With Selection.Find
.Text = SearchTerm 'Word to search for
.Replacement.Text = SearchTerm 'Replace with same word, different

formatting
End With

'Selection.Find.Replacement.ClearFormatting

With Selection.Find.Replacement
.Text = SearchTerm
.Font.Color = wdColorBlue 'change the text to blue
.Font.StrikeThrough = True 'cross it out
End With

Selection.Find.Execute Replace:=wdReplaceAll

Next x

End Sub
 

Read other answers
RELEVANCY SCORE 86.4

Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows 8, 64 bit
Processor: Intel(R) Core(TM) i3-3110M CPU @ 2.40GHz, Intel64 Family 6 Model 58 Stepping 9
Processor Count: 4
RAM: 3911 Mb
Graphics Card: Intel(R) HD Graphics 4000, 1827 Mb
Hard Drives: C: Total - 456899 MB, Free - 409599 MB;
Motherboard: Gateway, VG50_HC_CR
Antivirus: McAfee Anti-Virus and Anti-Spyware, Updated and Enabled

I am using find/replace to find double spaces between my sentences and replace them with single spaces in MS Word 2010.
In the first document that I open, Find/Replace works great. In any document after that the function will not work. It will usually add a space or two instead of subtract it.
If I close out the documents and shut down my laptop, power back up, open a new document, then it will work, but only for the first document again.
So frustrating and time consuming. I could have done it all manually with the time I have spent researching.
HELP!!

Elle
 

Read other answers
RELEVANCY SCORE 86.4

Hi,
I want to find and replace a line like this:
you can find at http://www.bing.com/maps/ .
The problem is i can't find this line on "Find what" box, so the replace function didn't work. I can find "you can find at" or "http://www.bing.com/maps", but when i find "http://www.bing.com/maps/", or even "maps/", nothing was found. I even added "\" to each "/" character and use wildcard, but it still didn't work. I really don't know what the problems is, someone help me pls .
 

A:Word 2007 Find and Replace problem

I don't have 2007 but tried it in 2003 and it worked. Check to make sure there isn't an additional space that slipped in between the word "find" and "http".
 

Read other 1 answers
RELEVANCY SCORE 86.4

If it was in WP, I would call it a "hard return". A user has created a table in Word 233 pages long. Whenever she needed to return to a new line in the same row, she would hit the enter button instead of shift+enter. This table needs to be in Excel. Whenever I convert to Excel, Excel treats each "hard return" as a new row.

I'm trying to use find and replace to find the "hard return" and replace it with a space. I can't find how to do that anywhere! Whenever I say to find the paragraph symbol, that doesn't work. Please someone help me on this. I have an attorney tapping her foot waiting for this.
 

A:Solved: WORD Emergency - Find & Replace

I see you mark this as solved so I take it you no longer need a solution? If you have solved this on your own could you please post the solution so that others may benefit from it in the future.

Regards,
Rollin
 

Read other 2 answers
RELEVANCY SCORE 86.4

Hello-I'm hoping someone out there can help me with this. I have a mailing label merge template set up in Word. Some folks in our database only have one address line so whenever I perform a merge the second line on the label for those people is blank. I have to a find and replace to fix it each time before I can print the labels.

Does anyone know how or if there's a way to get the template to automatically find and replace so I don't have to do it each time?

Thanks for any suggestions!
 

A:Auto Find/Replace in a Word template

There are other fixes for this, such as altering the merge field code. For instance, this article tells you how to do it in Word 2000:
http://support.microsoft.com/kb/264722

However, a quick F/R would be:

Put ^p^p in the FIND box.
Put ^p in the replace box.
Replace all.
 

Read other 2 answers
RELEVANCY SCORE 86.4

In a MS word document , how can i delete the words in the format '(2sec) 'or '(3sec)' or '(10sec)' like wise.
tat is '(an integervalue 'sec')'

here bracket also included in the word.
I used find and replace option but i couldnt formulate corresponding wildcard
 

A:doubt in find and replace option in ms word

What are you trying to replace those words with? You can't use *find and replace* without the replacement word or phrase. If you just want to delete those words, you can use *find* and click on *find next* to move through the document, deleting as you go.
 

Read other 3 answers
RELEVANCY SCORE 86.4

I just ran the Document Inspector on a Word 2007 document. It reported that "Custom XML data was found". I don;t know what that is and I never intentionally created any. But before I allow the Inspector to remove it, I'd like to see what it is.
 
How can I find it?
 

A:How to find "Custom XML Parts" in a Word (2007) document

Hope that helps you out. http://office.microsoft.com/en-us/excel-help/remove-hidden-data-and-personal-information-from-office-documents-HA010037593.aspx#BM1

Read other 6 answers
RELEVANCY SCORE 86.4

I opened a word 2010 document from an email in windows live mail desktop version and made some lengthy changes. Now I cannot find the document on my windows 7 system anywhere.

Please help

Peter

A:I cannot find a word document I opened as an email attachment

The file will be located in a folder somewhere in
C:\Users\(youraccount)\AppData\Local\Microsoft\Windows\Temporary Internet
Files\

"\AppData" is normally hidden
"\Temporary Internet Files" is normally a hidden protected Operating System
file

You'll have to remove the checkmark (if they're hidden) in Windows Explorer:
Organize - Folder & Search Options - View

Good luck in finding it, though.

The correct way is to save the attachment first, then open it
from the saved location, if you wish to edit it.

Read other 3 answers
RELEVANCY SCORE 86.4

I opened a word 2010 document from an email in windows live mail desktop version and made some lengthy changes. Now I cannot find the document on my windows 7 system anywhere.

Please help

Peter

A:I cannot find a word document I opened as an email attachment

a very obvious question which is.. did you save it in your computer? you may also check the recent docs you opened by going to file>recent

Read other 3 answers
RELEVANCY SCORE 85.6

Hi, I need some help!!

This guy has a document it is 33 pages long. He goes to edit, find, he types in "asian". he cancels out after it comes up with the find. he then presses ctrl-end to go to the bottom of the document. when he hits ctrl-page up it goes to page 19 finding the word asian. It should just go 1 page at a time back up, but continues to find asian. on the scroll bar(lower right) the double arrows turn blue when he first hits -find- after typing in asian? I checked many things. any ideas? hopefully you can make me feel stupid!!
 

A:(Resolved) word 2000 find and replace command

Tim: Since '97, that little ball between the upper and lower arrow now change to "find" instead of page up/page down. To change it back to page up/down, you need to hit the little ball and select the top-right icon to get it to go page by page again.

I hated it too when it first came out.

------------------
~dreamboat~
Brainbench MVP for Microsoft Word
Brainbench
 

Read other 2 answers
RELEVANCY SCORE 85.6

I have Word 2010 installed on a Dell Latitude E6520 with Win 7/Pro SP 1, i5 processor, 8 GB RAM.

I want to find and replace as follows:

SteEring with steering and similar spelling errors, such as: CheEring, PeEring, JeEring, etc.

Entries are:

Find what = Ering
Replace with= ering​Using the "Match suffix" option, the following message is displayed when the "Replace All" button is clicked:
​​Word has completed its search of the document and has made 4 replacements.

However, no replacements occurred.

This behavior is the same for Word 2010 (Windows) or Word 2011 (MAC - an acquaintance's computer).

So, am I missing something or is this a bug?

I have searched this forum and tried several web searches, all unsuccessful. Can anyone help?
 

A:Solved: Word 2010 Find and Replace Failure

I was able to duplicate your problem and correct it by checking the Match Case option using Word 2007. Should probably work for 2010, too.
 

Read other 2 answers
RELEVANCY SCORE 85.6

Aloha...

I have a Word 2007 manuscript with headings styled as heading1.

I need to append <HA> to the beginning of each heading, ie:

Trapping Errors
<HA>Trapping Errors

If the line had no style, I could probably use the wildcards ^13*^13 in Find and Replace. However, since the line is a different style from the body text before and after it, the first ^13 is not found.

Any ideas how I can do this? Please?

(The ultimate goal is to run a macro to do this for each chapter of a 600+ page book.)

TIA.

tanalee
 

A:Solved: MS Word: Find and replace line using wildcard

Aloha...

I barely know a thing about VBA, but with help, managed to put this together. It's not pretty, but it works. : )

Sub MarkHeadingsForEditor_ori()
Dim foundText As String
Dim newText As String
Dim blnFound As Boolean

Do
blnFound = False

With Selection.Find
.Style = ActiveDocument.Styles("heading1")
.Replacement.Style = ActiveDocument.Styles("heading1")

.Text = ""
.Replacement.Text = ""
.Forward = True
.Format = True
.MatchWildcards = True

End With

blnFound = Selection.Find.Execute ' after this line is executed, the heading1 text is selected
If Not blnFound Then Exit Do

foundText = Selection.Text ' ie, Testing VBA Procedures
Debug.Print foundText

newText = "<HA>" & foundText ' ie, <HA>Testing VBA Procedures
Debug.Print newText ' the text is replaced

With Selection
.Text = newText ' the new text is inserted
.Style = ActiveDocument.Styles("heading1") ' the heading1 style is restored
End With

Loop While blnFound
End Sub
 

Read other 1 answers
RELEVANCY SCORE 85.6

I can see the info in my document that I am trying to replace, but Word returns the reply, "Word has completed its search of the document and has made 0 replacements." Actually trying to replace a Paragraph symbol with a Tilde. Have tried other senarios just to see if it worked at all and have gotten the same results.

Using Word 2010 from MS Office Pro, on Windows 7 (64-bit) operating system. System has tons of space and memory.
 

A:Solved: Word 2010 won't perform Find and Replace

Read other 7 answers
RELEVANCY SCORE 85.6

Windows XP + Office 2003. In Word, the Find and Replace function just stopped functioning. It goes through the motions, but reports "Word has finished searching the document. The search item was not found." --no matter what the search item was, and even if it occurs a gazillion times in the doc.

Below the window where you enter the search item, it says: "Format: Right." I have no clue what this means (opposite of Format: Left? of Format: Wrong?) or how to change it if it should be changed.

I thought the problem might be a disabled service, but I can't find any candidates in the list of services.

So I need help.

Stephen
 

A:MS Word 2003 Find & Replace stopped working

You may have inadvertently selected some formatting. Click on "More" (with a little arrow beside it) to expand the box and then at the bottom right click on "No Formatting".
 

Read other 3 answers
RELEVANCY SCORE 84.8

I am editing a Word document (using Office 2002) with repetitive errors best solved with the Replace function of Word.

The string I am trying to edit is text with a number, for example:
Exercise9 [Title of Exercise 9]
Exercise10 [Title of Exercise 10]

I would like to change this to:
Exercise 9: [Title of Exercise 9]
etcetera

Thus far I have tried the following using Find, Wildcards
([A-z]{8})([0-9]{1,2})
and this seems to be able to find all the instances I am searching for.
However, when I try to replace it, it doesn't seem to work.

I have used the following to replace:
\1 \2:

And I end up with --> Exercise9: [Title of Exercise 9]

(Note: If the backslash appears as the "yen" symbol, it is because I'm using a Japanese OS.)

Edit:
Similarly, I would like to add "the" to the following two phrases:
Click Apply button OR Click Tools menu
where the second word is variable (i.e. directions to click a wide variety of buttons or menus)

I tried the following string.
Find, Wildcards: (Click) ([A-z]{1,}) ([menubto]{4,6})
Replace: \1 the \2 \3

but the result is, for example
Click Apply button the

Just to test it, I tried reversing the segments as such
Find, Wildcards: (Click) ([A-z]{1,}) ([menubto]{4,6})
Replace: \3 \2 \1

and it came up with what is expected: button Apply Click
so it seems something is right, but then again something else is obviously wrong.. it's just not obvious to me.
Any help is appreciated. Thanks.
 

A:Word Find and Replace with Wildcards - inserting colon and space

Read other 15 answers
RELEVANCY SCORE 84.8

http://www.youtube.com/watch?v=tt3ac0inzbM

MS work 9.0 dosent have a more button! how do I do it!
 

A:Microsoft Word Find and Replace! make essays bigger!!! HELP!

Not really a Windows Vista topic!

Try reposting it under Other Software forum where it is more appropriate.
 

Read other 3 answers
RELEVANCY SCORE 84.8

Hi,

I want to find and replace the Date format in word, if there is any macro coding for this. I try to using the following codes

Selection.Find.ClearFormatting
Selection.Find.Replacement.ClearFormatting
With Selection.Find
.Text = " 7/"
.Replacement.Text = " 07/"
.Forward = True
.Wrap = wdFindContinue
.Format = False
.MatchCase = False
.MatchWholeWord = False
.MatchWildcards = False
.MatchSoundsLike = False
.MatchAllWordForms = False
End With
Selection.Find.Execute Replace:=wdReplaceAll
End Sub

But "7" is relates to month, so if there is any code for change the numeric character to specific date format as "mm".

For ex :

BUARDC 04294008295 010321 6000 7/17/2010 0000354652 000224

The above is the example data , in that month needs to added a leading zero.

Thanks in advance
 

A:Solved: Find and replace the date format in Word file

Read other 16 answers
RELEVANCY SCORE 83.2

Hi all,
I recall being able to add the "find and replace" option to OE a while back. I think it was linked somehow to Microsoft Word or Notepad which has this option. I would like to remove (<<) from forwarded emails directly in OE rather than having to cut and paste to notepad and remove the (<<). I know my old imac's OE had an option to "clean up text" or simular which removed all the quotes. I don't see this in todays OE for XP though.

I do recall there being a tweak that added this function though.
Thanks in advance,

Monker

A:Outlook Express Edit>find>(find And Replace?)

I've never noticed that option, in OE.Just a suggestion, but I find StripMail to be faster, than using Word.StripMail is a FREEWARE utility that: * Strips the characters ">" and "|" from forwarded e-mails. * Formats the text into paragraphs, making it easier to read. * Changes the text's right margin, by indenting. * Can be used with any e-mail client.

Read other 4 answers
RELEVANCY SCORE 78.4

Hi all I want to find duplicates in a given column, selected by the user at run time, and then I want to copy the duplicates to a seperate sheet. For example:

Say I have a these columns:

1 100021
2 100031
3 100031
4 100041
5 100051
6 100071
7 100051

So the numbers 100031 and 100051 would be copied to a new sheet called duplicates.
The list of numbers can be of a varied length (between 100 and 1000 lines long).

I want to create a macro that performs this task. Could anyone provide me with any assistance?

Thanks

Greg
 

A:Find duplicates in excel.

Hi Greg,
You could record a macro to do that. Since you haven't mentioned which version of Excel you're using I can't tell you which menu option to choose.
In Excel 2003 you can use the Advanced filter option under the Data menu to create a list of unique numbers and then add a counter to this list to show which occur more than once.

I could put a simple macro together for you.
See if you can work it out using the advanced filter. first, and ... don't formte to mention which version of Excel you are using.
 

Read other 2 answers
RELEVANCY SCORE 78.4

Hi, i have a database in access 2003. I currently have around 40,000 records and i know there are duplicates. Is there any code or a macro that will search through the table, if a duplicate record is found discard that record then carry on searching till finished.

Any help will be appreciated.
 

A:VBA or Macro to find duplicates

Have you tried the ' group By' I suggested in the other post?
 

Read other 2 answers
RELEVANCY SCORE 77.6

Hi all,

At the office we have a data base of about 12000 customers. actually it is 12000 orders. some customer purchased from us several times. We want to send our customers a letter and introduce a new item that they may want.

the actual number of customers is about 8000 and it would cost a lot of money to send out the unneeded 4000 letters. So I am trying to find a way to eliminate the duplicates.

the database has several fields:

order # -- First Name -- Last Name -- Address -- City -- Zip

I could sort the database by address and take out the duplicates 1 by 1 witch will take forever.

I'm hoping someone here knows how to set up a query to do the job.
also, please tell me in plain English how to set it up.
Thanks
Sven

A:Find duplicates in Access 2013

Hi,

You will find a tutorial here:

Queries: How to Create a Find Duplicates Query

It's difficult to provide step by step instructions without being able to see the data. One problem is that finding duplicates requires exact text matches in the fields that you want to query for duplicates.

First Name and Last Name are no good unless they're unique.

Example:

C Smith
C. Smith
Chris Smith
Chris A. Smith
C.A. Smith

They might well be the same person but a duplicate query won't pick this up.

Address field:

123 Some Road
123, Some Road
123, Some Road, Some Town

A duplicate query won't pick this up either.

Find the most unique field (probably Zip) and compare that.

I find that sometimes the best way is to copy the table into Excel and use the find duplicates add on from asap-utilities to remove duplicates rather than using the remove duplicates function that's built into Excel.

With your duplicates removed you can copy the data back into a COPY of your Access database. (A cleancopy with the data removed before you re-populate it).

ASAP Utilities for Excel - Search in the description of all the utilities of this Excel add-in

Sorry, can't give step by step instructions as I don't use MS Office on my home machine. I only use it at work!

Read other 9 answers
RELEVANCY SCORE 77.6

Hi,

in my database i need to find duplicates in the customer table, but i only want it to find duplicates if the customer does not have any orders.

Example:

Karl Haywood 1 order
Joe Bloggs 1 order
Karl Haywood 0 orders

so the duplicates query would find "Karl Haywood" but i only want to delete the one with 0 orders. Is this possible??
 

A:Find duplicates in access 2003

Read other 9 answers
RELEVANCY SCORE 77.2

I don't know why they changed this. I hate the navigation pane you get now when you use Crtl + F instead of the Find & Replace. It's a real "pain", yes pun intended. Now I know Find & Replace is Crtl + H but after x number of years using Ctrl + F I just can't get used to switching. Plus, it's still Ctrl + F for searches on websites, etc. so it's very confusing.

So my question is, is there any way to change the keyboard shortcuts so Ctrl + F would bring up Find & Replace like before?
 

A:Solved: Keyboard Shortcut for "Find & Replace" in Word 2010

Read other 10 answers
RELEVANCY SCORE 76.8

Dear All,

Can you plz suggest me a software that can find duplicate texts present in an excel file? I know there is an option called "Remove Duplicates" under Data section in excel, but it can only find duplicates present in the current worksheet.
What i am looking for will allow me to find duplicates present in diff worksheets of the excel workbook.

Any suggestion?

Thanks in advance,
Troy.

A:Need software to find duplicates in excel worksheets

Hi Troy

Maybe something useful here:
Highlight Duplicates, Macro? - ExcelBanter

Read other 3 answers
RELEVANCY SCORE 76

Long time PC user, newbie to the Mac.

Here is my problem:
1. I have duplicate songs in my iTunes Library
2. My original playlists can't find the original song.

Here is how i think i got there:
1. When things worked, i pointed my iTunes to an external hard drive - Let's call this hard drive (A). This hard drive was PC formated, so i couldn't write to it.... only read.
2. Recently bought a new hard (B). Copied iTunes folder to NEW hard drive (B) - reformatted original, and then moved the iTunes folder back to hard drive (A).
3. From iTunes, sometime during the above step, i changed the destination of iTunes songs to the MacBook iTunes folder. Then i changed it back to the hard drive (A).
4. Once iTunes scanned through the songs and completed this step, every song still had a '!' next to it. None of them could be played because the original song could not be found.
5. I then went to File > Add to Library..... i can see now this step created 'duplicates' in my iTunes Music library. So now, each song is listed twice, one can be played, and the other has the '!' All my playlists still have the '!' and i can no longer sync these playlists to my other devices (iPhone/iPods).

Can someone help me solve my problem?
 

A:iTunes unable to find song location and now have duplicates

In your preferences tab (edit -> preferences -> advanced, this is for windows), where does your iTunes folder reside? Is it set to the external drive? I assume you want it to reside in your external drive. Is the "Keep iTunes folder organzed" and "copy music to iTunes folder" boxes checked?

If the "keep iTunes folder organized is not checked, check it and close the window; iTunes will organize itself automatically, but make sure your folder is set correctly (the drive you want the music to reside in). Once its done, close iTunes and restart iTunes again. That should take care of the exclamation marks on the songs.

As for duplicates, you have to go song by song and remove them. But you need to make sure that the duplicate songs are actually duplicates in your music folder. For example, if "Song A" is listed twice, Right click on the song and go to Get Info for each song. At the bottom of the window, "Where" the song is located is listed. If 2 of the same songs exist in the folder, one track will say "Song A" and the other track will say "Song A 1." At this point when you delete the song, you can also delete the file when iTunes asks to delete the file. Now, if you click on get info on both songs and the it says "Song A" for both songs, you can delete one of the tracks from the list, but don't delete the file when iTunes asks, otherwise the song will removed. Does that make sense?

The easi... Read more

Read other 1 answers
RELEVANCY SCORE 72.8

Hello

I have a need to find a text of X in a document go to end of line select whole line and delete line and then find next X in document. With 3500 X Id like to loop till end of document. In 2010 my (pc at home) the find X part of a recorded Macro does not show up. In 2007 it shows up so I can see how it works at office. I just need to know how to loop, the above of instruction "find X, select whole line, delete, find next X" and loop this.

Eg

YYYY 1
AHKJUSKL XX
AGSJUJ ()*(IO XX
ASJ
L:JOPO
AKLSJXX
DADAD

needs to look like

YYYY 1
ASJ
L:JOPO
DADAD

using XX as the reference of which line to delete.

Cheers
Al
 

A:Solved: Word Macro Loop of 1) Find 2)Select line 3)Delete line 4)find.

Read other 6 answers
RELEVANCY SCORE 70.4

Hello...

[I need to know if there is a function...perhaps a Macro or Query...or a more complex 'Find & Replace'...that can accomplish the following...'cause my database is huge; & I'm hoping not to do this manually]:

I keep an Access database for my homeowners' association on the condition & conformity of 24 different exterior attributes, for about 2400 townhomes. The Board of Directors wants to move away from using the term "Grandfathered", which is distinguished by the acronym "GF" in the database column that shows conformity (labeled IAW). We use this database to generate annual architectural reports for our 10,000 residents.

Our board wants the entry "GF" replaced with a "Y"...they want the GF entry removed from the report completely; & they're serious about it.

Now...I have already created a Query that has located all the GF entries in their various columns of various records...which our Board wants me to use in an internal "in-office" database (in order to keep track of what attributes actually were grandfathered originally...as a reference for our field inspector when he inspects the townhomes).

But we also want to create an unassuming symbol on the report...perhaps an ~ or a *...something that will alert the inspector to an attribute that once was grandfathered, on his field report. [This is to be done so that he will not
be flying blind when he comes across a non-con... Read more

A:Find & Replace (but Replace in a different Column)

see attached. But actually getting that data back to the table, if that is what you want, is a bit trickier.
 

Read other 3 answers
RELEVANCY SCORE 69.6

A few months ago I encrypted a couple of Word documents but now I can't remember what I named them or where they are. How do I find them again? I'm using Vista Ultimate 64.

A:find a document when you don't know it's name

Hello Skootch,

Press the WINKEY+F keys to bring up the search window. At the top/right,
click Advanced Search.

In the Location drop down menu, select a drive or click the Choose Locations
and select where you want to perform the search. In the Name box, type
*.doc (or *.docx) and click the Search Button.

Let me know if that works for you.

Read other 3 answers
RELEVANCY SCORE 69.6

When I create a text file in either Open Office or MS Works and then save it, I can find it and open it in the program that created it, but NOT in the Documents library! Why?

A:Can't Find Document

Perhaps because the folder you are saving it in is not included in the Documents library.

Right click the folder containing the document(s). Select Include In Library, select Library.

The Library is not a location, per se. It is like a relationship of locations.

Read other 2 answers
RELEVANCY SCORE 68.8

Excel 2007 - I would like to do a Find and Replace a word and when I do it changes the entire cell by taking the words which have color and truning them black and changing my fonts to one size. How can I just Find and Replace just one word in a cell? Is there anyway I can do a find and have all the words highlighted like when you do a find on the Internet?

A:Find and Replace

  
Quote: Originally Posted by lostsoul62


Excel 2007 - I would like to do a Find and Replace a word and when I do it changes the entire cell by taking the words which have color and truning them black and changing my fonts to one size. How can I just Find and Replace just one word in a cell? Is there anyway I can do a find and have all the words highlighted like when you do a find on the Internet?


I'm not sure if you can highlight the word but you can change the color of the font, shade the cell etc. Find & select, replace, format, text & fill.

Read other 6 answers
RELEVANCY SCORE 68.8

Anyone can recommend me a good "Find & Replace" freeware?

Thanks.

Nikas

A:Find & Replace

I found Simple Search/Replace.No installation needed. Just extract to any folder and run the file from the folder. Simple and easy. Pretty good. Any one with other good Find & Replace software to share?

Read other 1 answers
RELEVANCY SCORE 68.8

I'm helping to create a website for my boss. I am copy/pasting descriptions of products, but I need to replace all the bullet points manually with <il>. It's super time consuming and I'd like to find a quicker way to complete this project. Weekends are for comic book reading and video game playing! Poop on working weekends! Does anyone here know how I can do a "Find and Replace"?
 

A:Find and Replace?

Read other 13 answers
RELEVANCY SCORE 68.8

In Excel 2007, is there a way to replace "/" with a " "? In other words, find and replace front slashes with blank spaces.

A:Find and Replace

Unless 2007 excel differs from previous versions, select the range, Edit &gt; Replace, type in / in the upper box, type in 2 spaces in the lower box and Replace one or all.

Read other 1 answers
RELEVANCY SCORE 68.8

I find this feature very useful and very powerful in Word 2003.

However I have found the following code in a document without knowing what
it does. I think it is linked with some Find and Replace sequence.

(<*) ([! ]@)^13

Can anyone explain what each bit of code does sequentially ?

Regards
 

A:Find AND Replace

That doesn't look like code, looks like plain machine garbage. Sometimes it's because of corruption or not being able to substitue a font.
 

Read other 1 answers
RELEVANCY SCORE 68.8

I have a Dell Inspiron 3650 with the I7 6700 and 16gb DDR3 ram.  My computer came with a 250 watt power supply, and I'd like to upgrade to something more powerful.  The issue I'm having is that after finding the model number for the SFF power supply I didn't see any sites that specifically said it could replace this power supply.  
I'd like to get a 400 watt or more PSU, but not sure what specs I need.  Any help would be greatly appreciated.

A:Need to replace PSU, but not sure how to find what I need

gft77
I have a Dell Inspiron 3650 with the I7 6700 and 16gb DDR3 ram.  My computer came with a 250 watt power supply, and I'd like to upgrade to something more powerful.  The issue I'm having is that after finding the model number for the SFF power supply I didn't see any sites that specifically said it could replace this power supply.  
I'd like to get a 400 watt or more PSU, but not sure what specs I need.  Any help would be greatly appreciated.


gft77
The Inspiron 3650 [Gamer] has a Dell Proprietary power supply that is bad news and cannot be upgraded, as there are no retail equivalent power supplies available.

There is a workaround this issue, posted Here:
http://en.community.dell.com/support-forums/desktop/f/3514/t/19657974
Bev.

Read other 1 answers
RELEVANCY SCORE 68.8

I have MS Office 2003. I have looked in the Options trying to find where I can change my path to my documents, it is incorrect since I moved them. I felt sure it was there but I can't find it. Where should they be? Thanks,

A:Trying to Find Document Path

i've not used office 2003 for a long time now, so i forget how it works.

does it not remember the last path used?

or try changing the properties of the shortcut you use to start it with:

i know it's a different version, but you get what i mean.

Read other 6 answers
RELEVANCY SCORE 68.8

I had to download a project template from my online school to complete a project. Once I downloaded it I enabled editing and went on to work on my project. Throughout I saved many times under my files name (IT Final) and it was located in word documents.
Right before I closed word I made sure I saved one more time, and closed. Now I can no longer find it anywhere. I have searched in word itself, under documents for my computer, by save date and time, by file name, and anywhere else I could think of. It is
literally no where. This is not the first time this has happened to me, every other time I just restarted because I wasn't that far in. This time I am four hours in and the project is late so I do not want to lose time worked. PLEASE HELP.

Read other answers
RELEVANCY SCORE 68

We have a TON of text based INI files for our companies software deployment scripts.

We also have a TON of people who use different ways to deploy the same software. On one server alone we can have a bunch of different ways people install E.G.

msiexec.exe /quiet /norestart /i \\dfs\dfsshare\SAV\Symant~1.msi
msiexec.exe /quiet /norestart /i <qt/>\\server\share\WIN32\Symantec Client Security.msi<qt/>
msiexec.exe /quiet /norestart /i \\server\share\SAV\WIN32\Symantec Client Security.msi
msiexec.exe /quiet /norestart /i <qt/>\\dfs\dfsshare\SAV\Symantec Client Security.msi<qt/>

and so on down the line.

I LIKE the abilities of Ecobyte Replace Text 2.2 but the problem is I have to type in the whole line as it is in the file to then replace it with the new one for the new deployment.

What I want to do is have a search based on PART of the line so I can then put in Symant~1.msi and Symantec Client Security.msi and replace the ENTIRE line with a new line.

Is there any multi file utility that allows you to search for part of a text line but replace the entire text line?
 

A:Need a robust text find and replace utility - Like Ecobyte Replace Text 2.2 but not

Read other 6 answers
RELEVANCY SCORE 68

Hello, I need your help. My display is broken and I need to replace it but I can't find the product number in HP PartSurfer.I bought it in Greece but now I'm living in United States. Pleace Help me with the information to buy it new.In the Product Specifications it just says:43.9 cm (17.3") diagonal HD BrightView LED-backlit (1600 x 900)It is not helpfull This is my Laptophttp://support.hp.com/us-en/product/HP-Pavilion-17-f000-Notebook-PC-series/6936220/model/7171988/tro... Thanks for your help!

A:Hello, I need to replace my display but I can't find the pro...

Hi, Page 88 of the Maintenance and Service Guide, 4th manual on the folloing link may help you to work out which one       http://support.hp.com/us-en/product/HP-Pavilion-17-Notebook-PC-series/6936220/model/7171988/manuals Regards.

Read other 1 answers
RELEVANCY SCORE 68

I'm searching for *, and replacing it with nothing which is working the way I want it to work. the fields are 00000000,00000000,00000000 or 00000000,00000000,00000000,00000000,00000000. How can I do the same thing in a query that takes the first 8 digits before the first comma and gets rid of everything else?
Bill
 

A:query that does what I'm doing with Find and Replace

In what program?
 

Read other 1 answers