Windows Support Forum

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

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

We have Ecobyte find not replace Need utility and robust Replace - a 2.2 text but Text Like 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 msi msiexec exe quiet norestart i lt qt gt server Need a robust text find and replace utility - Like Ecobyte Replace Text 2.2 but not share WIN Symantec Client Security msi lt qt gt msiexec exe quiet norestart i server share SAV WIN Symantec Client Security msi msiexec exe quiet norestart i lt qt gt dfs dfsshare SAV Symantec Client Security msi lt qt gt and so on down the line I LIKE the abilities of Ecobyte Replace Text 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 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 nbsp

Relevancy 100%
Preferred Solution: Need a robust text find and replace utility - Like Ecobyte Replace Text 2.2 but not

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/directdownload.php. (This link will automatically start a download of Reimage that you can save to your computer.)

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

https://forums.techguy.org/threads/need-a-robust-text-find-and-replace-utility-like-ecobyte-replace-text-2-2-but-not.837870/
Relevancy 95.79%

Hi I need to use the search and replace function here s what i wanna do Note I have not used any regular expressions here i wanna find this resource activeprofile py quot - quot private a bd c and replace it by resource activeprofile py quot - Find text and [Help] Replace quot resource now the name quot activeprofile py quot has to be the variable as its not the same for every entry so its something like this Find this resource quot - quot private a bd c and [Help] Find and Replace text replace it [Help] Find and Replace text with resource quot - quot resource where is whatever the filename is and it should not get replaced also if its possible [Help] Find and Replace text can i search for quot - quot private a bd c and replace it with quot - quot where is what was in the place of when text was found and is what was in the place of plz help me and reply quickly this is a pkg script for a SIS file for symbian installation Thank you very much in advance will be able use any text editor nbsp

A:[Help] Find and Replace text

ok, i can now find the text i want to replace using this Regular expression

\\resource\\(\w+)\.py"-"\!\:\\private\\a000bd8c\\

but how to replace it so it looks something like this

\\resource\\(\w+)\.py"-"\!\:\\resource\\

where (\w+) remains unchanged??

someone plz help me on this!
 

https://forums.techguy.org/threads/help-find-and-replace-text.790512/
Relevancy 94.55%

Hi. I am trying to format a script in Microsoft Word for Mac and I'd like to be able to find every bit of text in parentheses and replace it with the same text in italics (including the parentheses themselves). I've tried to figure it out using wildcards and such, but I keep getting error messages that I'm not doing something right.

I'd appreciate any code I could use to do that.

Thanks!

http://www.techsupportforum.com/forums/f57/find-and-replace-text-in-parentheses-1143650.html
Relevancy 93.62%

Hello,

I have multiple text files (very large) containing text split by the delimiter $. Unforunately some of the data contains the dollar sign which is preventing me uploading the file into my data analysis tool. I can identify the difference between a delimiter and a standard dollar sign as the delimiter is always preceded by -} ie -}$. I cannot set this as the delimiter as it affects the way the data is read in my tool.

I need to alter the delimiter from $ to $$.

Can you help me find a way to automatically (using a .bat file) open the text files in the directory and replace ever instance of -}$ with -}$$?

Many thanks for your help
 

A:Batch Find and Replace on a text file

Welcome to TSG!

Do the files contain any of these characters:
"<>&^%|
If so, it would be much easier to use something like Replace Text, which can so a Search and Replace on multiple files. I haven't used it much so I can't be 100% certain it doesn't have issues with some characters though.
SwissFileKnife can do it from a command line. It does not make a copy, so backup the files first just in case.
This will replace -}$ with -}$$ in all .txt files in the C:\Test1 folder and it's subfolders as well. If you don't want to process subfolders add -nosub

Code:
sfk rep -text /[COLOR=Red]-}$[/COLOR]/[COLOR=Magenta]-}$$[/COLOR]/ -dir [COLOR=DarkRed]C:\Test1[/COLOR] -file [COLOR=Blue].txt[/COLOR] -yes
If your files don't have any of those characters, this batch file should work:

Code:
SetLocal EnableExtensions
Set _Source=C:\test1
Set _Dest=C:\Test2
If NOT Exist "%_Dest%" MD "%_Dest%"
PushD %_Source%
For /F "Tokens=1 Delims=" %%A In ('Dir /A-D /B *.txt') Do (
If Exist "%_Dest%\%%A" Del "%_Dest%\%%A"
For /F "Usebackq Tokens=1 Delims=" %%I In ("%%A") Do Call :_Sub "%%I" "%%A"
)
PopD
Goto:EOF
:_Sub
Set _tmp=%~1
>>"%_Dest%\%~2" Echo.%_tmp:-}$=-}$$%
Goto :EOF

 

https://forums.techguy.org/threads/batch-find-and-replace-on-a-text-file.845736/
Relevancy 92.69%

Hello all,
 
I'm using CodePlex Find And Replace Tool to find some text with numbers included. I'm using the text + an asterisk to find but nothing is found. (See attached pic) Am I using this wrong or is there some other method to Find and Replace? I really need some help. I've been working at this for over a week. Please help me.

A:Find and Replace numbers in multiple text files

What are you trying to replace and why?

http://www.bleepingcomputer.com/forums/t/526981/find-and-replace-numbers-in-multiple-text-files/
Relevancy 91.76%

Hi,
I compile my own PDF for my personal use from texts copied from other sources and other ebooks I have purchased. When I copy texts from other PDFs, the chapter title, page # and book titile appear multiple times (same as # of pages) in the big single document I have pasted.
Is there any software which will find repeating phrases sentences in a big area of text so that I can replace/remove them?
the function/app should list all repeating phrases in the selected text area and offer suggestion to replace/remove
thanks in advance
 

A:Any Repeating text/phrase finder function/software for text editor? replace/remove?

https://forums.techguy.org/threads/any-repeating-text-phrase-finder-function-software-for-text-editor-replace-remove.931238/
Relevancy 91.76%

How do I replace"wxyz" with "CRLFwxyz" using the find & replace function in a text editor? This seems like a simple request but everyone wants to make it complicated. Please, just using using the find & replace function!

A:Find & Replace wxyz with CRLFwxyz function in text editor

If by CRLF you mean "carriage return and line feed" then I don't think it's a simple request because it's not allowed as a normal Replace function. If you just want to add the letters CRLF in front of wxyz then it's easy - you just do it.Gotta a feeling I've missed the point on this. No doubt I'll soon get put right.Always pop back and let us know the outcome - thanksmessage edited by Derek

http://www.computing.net/answers/windows-7/find-replace-wxyz-with-crlfwxyz-function-in-text-editor/19262.html
Relevancy 91.45%

Text files were Solved: Text Replace Paragraph Editor To Mark In Text With Need created within excel by concatenating cells in each row Each row became a text file The contents of the text file are the contents of an html file After the text file is created Solved: Need To Replace Text With Paragraph Mark In Text Editor I change the file extension of the text file to html I need a mass replace text editor so I can replace the word paramark in the txt file to be renamed as an html file with Solved: Need To Replace Text With Paragraph Mark In Text Editor a real paragraph mark that shows as a paragraph mark in Front Page The problem with doing what I am doing is when all the cells are concatenated in Excel all the html contents end up on one line rather than having paragraphs separate the html lines Example The Way The HTML Code Should Be Code lt html gt lt head gt lt title gt Memory Master Bible Memory Program - NIV - Peter lt title gt lt meta name quot Microsoft Border quot content quot tlb default quot gt lt head gt Example The Way The HTML Code Turns Out After Using Excel To Create The File Code lt html gt lt head gt lt title gt Memory Master Bible Memory Program - NIV - Peter lt title gt lt meta name quot Microsoft Border quot content quot tlb default quot gt lt head gt I can place text to be replaced paramark next to each paragraph mark so if I can find a text editor to mass replace a real paragraph mark in place of the word paramark my problem is solved I have four thousand files to process so I need to do a mass replace across files Thank you in advance for any replies nbsp

Relevancy 90.52%

Hi Guys I need help creating a dynamic macro that could save me alot of time in the future In a nutshell - quot Name quot value in Column A - quot Yes quot or quot No quot value in Column B - quot Name quot value in Column C I need - Every cell in Column Text Column Find, if Macro Found - In Need Another - 2010 Replace - Help Excel C to be crossed referenced with Column A - If there is a match I need the value in Column B to be changed to Yes Before ------Column A ------------------------------ Column B ------------------------------ Column C ------- ------------------------------------------------------------------------------------------------------------------------- -- Jen NO Jen -- -- Jane NO Need Help - Excel 2010 - Macro - Find, if Found Replace Text In Another Column Jane -- -- Sarah NO Sarah -- -- Mike NO James -- -- Mitch NO Fred -- -- Joy NO Lee -- ------------------------------------------------------------------------------------------------------------------------- Need Help - Excel 2010 - Macro - Find, if Found Replace Text In Another Column After ------Column A ------------------------------ Column B ------------------------------ Column C ------- ------------------------------------------------------------------------------------------------------------------------- -- Jen Yes Jen -- -- Jane Yes Jane -- -- Sarah Yes Sarah -- -- Mike NO James -- -- Mitch NO Need Help - Excel 2010 - Macro - Find, if Found Replace Text In Another Column Fred -- -- Joy NO Lee -- ------------------------------------------------------------------------------------------------------------------------- Thanks for the help Ben nbsp

A:Need Help - Excel 2010 - Macro - Find, if Found Replace Text In Another Column

As just a Formula, put this in column B ' =IF(A1=C1,"Yes","No")'

As a Macro -
Sub MatchReplace()
Dim LastRowColA As String
LastRowColA = Range("A65536").End(xlUp).Row
For i = 1 To LastRowColA
Range("B" & i).Select
ActiveCell = "No"
If ActiveCell.Offset(0, -1) = ActiveCell.Offset(0, 1) Then ActiveCell = "Yes"
Next
End Sub
 

https://forums.techguy.org/threads/need-help-excel-2010-macro-find-if-found-replace-text-in-another-column.1062681/
Relevancy 88.66%

I'm working on a VBA script to look for all instances of the word 'john' in a Word 2010 document, and replace it with the same word 'john' but have it hidden.

I can't seem to get it working...can anyone help....

A:VBA search text and replace with hidden text

your solution fixed

http://www.bleepingcomputer.com/forums/t/413170/vba-search-text-and-replace-with-hidden-text/
Relevancy 80.6%

I would like to replace all italic strings, say TEXT with this: "\it{TEXT}". (I want to convert a doc document into LaTeX). In previous versions of Word, I simply achieved this by:

In Word 2002 SP3, however, instead of "\it{TEXT}", now I get "TEXT\it{}": the replace process inserts the text after the string to be replaced, and not around it. Could someone help me what Find/Replace code should I use to achieve \it{TEXT}? Thank you in advance!
 

https://forums.techguy.org/threads/word-2002-sp3-replace-italic-with-text-italic-text.973751/
Relevancy 108.36%

Hello
I need some help with Word (2003/2007)
I would like to search for a Text Box in my doc and convert it to a Frame with search and replace (in order to create a macro that would search and replace all text boxes with frames in the doc)
How can I achieve this?
If it is not possible, is there any other way to create a macro that will replace all text boxes with frames in my doc?
thanks a lot in advance...
 

A:Search and Replace Text Box with Frame in Word

Which? 2003 or 2007. They are really quite different.
 

http://www.techspot.com/community/topics/search-and-replace-text-box-with-frame-in-word.108659/
Relevancy 108.36%

The computer is Windows Vista, but I prefer Google Chrome to IE. All has worked very well until recently when I now get numbers in place of some letters in what I type. Incoming messages and general text are fine. Computer not old, but is it time to replace it or can it be fixed?
 

Relevancy 107.07%

I have a question. I've already looked online but I can't find a way to do this. Basically, what I want to do is take a select part of a document and change it (like the Replace feature of Notepad), but instead of replacing it with specific text, I want to change it to numbers, in consecutive order. Here's what I mean (let's pretend that I want to replace L):

Original Text
Sample TEXT L
Sample TEXT L
Sample TEXT L
...
Sample TEXT L
Replaced Text
Sample TEXT 1
Sample TEXT 2
Sample TEXT 3
...
Sample TEXT 100

And help with this question would be appreciated! Thanks!

I'm using Windows, by the way.

 

A:Solved: How do I Replace Specified Characters of a Text Document with Consecutive Num

Is this a Word document you're trying to do this in? You may have better luck using Excel. Both programs have the find /replace feature but Excel will allow you to easily number the text by putting Sample TEXT 1 in Excel cell A,1 then move your cursor to the bottom right of that cell until it becomes a bold + sign. Then just hold your left mouse button and drag down as far as you want to go.

The results will look like this.

Sample TEXT 1
Sample TEXT 2
Sample TEXT 3
Sample TEXT 4
Sample TEXT 5
Sample TEXT 6
Sample TEXT 7
Sample TEXT 8
Sample TEXT 9
Sample TEXT 10
Sample TEXT 11
Sample TEXT 12
Sample TEXT 13
Sample TEXT 14
Sample TEXT 15
 

https://forums.techguy.org/threads/solved-how-do-i-replace-specified-characters-of-a-text-document-with-consecutive-num.1139625/
Relevancy 107.07%

Is there multi line search and replace tool for text?

I need to search and replace multi lines of text files.

If there is a text file like this.






Quote:
WEBS (AM), a radio station at 1030 kHz, licensed to Calhoun, Georgia, United States
The Web (film), a film noir
The Web (TV series), a mystery/suspense anthology series
"Web" (Law & Order: Special Victims Unit), an episode of Law & Order: Special Victims Unit
Webs (film), a 2003 sci-fi movie
The Web, a dangerous region of space in the ReBoot universe
West End Broadcast (WeB FM), a radio station in Newcastle, England, that was a forerunner of NE1fm
"The Web", an episode from the first season of the British science-fiction series Blake's 7


Search for






Quote:
Webs (film), a 2003 sci-fi movie
The Web, a dangerous region of space in the ReBoot universe


Replace with






Quote:
Tech-Webs find et setra
setra setra setra setra setra

A:Is there multi line search and replace tool for text?

Looks like UltraEdit can do that:

Multiline find and replace

http://www.sevenforums.com/general-discussion/213434-there-multi-line-search-replace-tool-text.html
Relevancy 105.78%

Would anyone know of a downloadable freeware, search & replace text editor that has the flexibility to allow line oriented deletions or insertions based on a key-word? More clearly, I wish, for example, to be able to find every occurrence of a specified word in the text and delete whatever follows it in that line of text; or insert a specified string after (or before) the word.

It would be nice if the editor could remove blank lines or groups of blank lines.

The freeware editors I have found do not seem to have such flexibility. They work on multiple files; I don't need that. One file at a time would be fine for me.

Suggestions?
 

Relevancy 99.76%

Hello I need Replace in Find Column) different (but Replace & a to Find & Replace (but Replace in a different Column) know if there is a function perhaps a Macro or Query or a more complex Find amp Replace that can accomplish the following cause my database is huge amp I m hoping not to do this manually I keep an Access database for my homeowners association on the condition amp conformity of different exterior attributes for about townhomes The Board of Directors wants to move away from using the term quot Grandfathered quot which is distinguished by the acronym quot GF quot in the database column that shows conformity labeled IAW We use this database to generate annual architectural reports for our residents Our board wants the entry quot GF quot replaced with a quot Y quot they want the GF entry removed from the report completely amp 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 quot in-office quot 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-conforming attribute i e he will see the symbol amp know that that symbol means there used to be a quot GF quot in it s place BUT we want to move that symbol to a different column a column labeled quot Comments quot I could run the Find amp Replace function find all the GF s amp replace them with a Y but that symbol would go right back in the very same column that the GF came out of So is there a way to find all the GF s in one column amp replace them w a Y in that same column but have a symbol quot quot appear in another column of the same record I know it sounds complicated but can it be done Thanks mark man Access nbsp

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.
 

https://forums.techguy.org/threads/find-replace-but-replace-in-a-different-column.709333/
Relevancy 89.01%

Greetings! I've searched everywhere for the answer to this issue. It must be common, but I can't find it anywhere. I'm using MS Word 2007, but the problem was the same in 2003. I sometimes get a text box that is behind regular text. I need to move it. One normally just selects a text box and drags, or cut and paste, it where one wants. However, when it is behind text, it can't be selected. I have found no way to select normal text and "send it behind."

How do I get to this text box that is behind my regular text? I've been told to "move the regular text out of the way, then you will be able to get to your text box." But the text box moves with text!

Thanks,

7nyerik
 

A:Text box stuck behind regular text in MS Word 2003 and 2007, Can't select text box.

You can't post a link to your computer to post an image. We cannot access your computer. Upload the png image as an attachment please. To do that, scroll down to "Manage Attachments" then click on "Browse" to locate the file on your computer then "open" it and then click on "Upload" and submit your reply.
 

https://forums.techguy.org/threads/text-box-stuck-behind-regular-text-in-ms-word-2003-and-2007-cant-select-text-box.956324/
Relevancy 87.72%

On boot raid screen was saying mirrored drives were both degrading Rebooted and cleared replace utility error. mbr need to raid in in entered nvidia raid utility bare bones to look at drives Both looked good and could not understand warning message Saw the clear cleared mbr in raid utility in error. need to replace mbr and mistakenly thought I was clearing error messages Not too bright from this vantage point right now After much reading now realize what an mbr is and what it was that I pooched In any event have tried windows install disc to create a fix as well as testdisk I have test disk on a flash drive Windows on it's own cannot repair It doesn't even see When the flash drive is attached it sees but it still cannot make the repair It says so It also says to remove any media that has been attached I also followed a repair through the command prompt but that led nowhere and did nothing Is there a way to make this repair I do not have the ability to retrieve my data nor do I have a back up The mirror was supposed to be my back up Any help would surely be appreciated Thanks Bill

A:cleared mbr in raid utility in error. need to replace

Go into the BIOS --> Advanced --> peripheral config --> secondary Sata controller .... is it enabled or disabled?

http://www.sevenforums.com/installation-setup/282586-cleared-mbr-raid-utility-error-need-replace.html
Relevancy 86.86%

I have a couple of million .html files to change, so I need a batch way of doing them all at once. They change seems simple but it is turning out to be very difficult to actually get done right. Here is the situation. The files currently have this content:

<title>123 Product XYZ</title>
<meta name="description" content="Blah, blah, blah">

What I want is to end up with this content:

<title>123 Product XYZ</title>
<meta name="description" content="Blah, blah, blah 123 Product XYZ">

Can't figure out any way to do it. Please note that although I've been around computers since they were hacked from granite, I am not a programmer so I'm stuck. Any assistance would be appreciated! Happy holidays!
 

Relevancy 84.71%

Hi all The laptop in question is a Toshiba Satellite A -S A few weeks ago it got dropped right on its adapter? Replace the replace the or jack power corner Replace the power jack or replace the adapter? with the power plug still in it the little metal plug of the AC adapter is now slightly crooked and the power jack has a little chip off the plastic part of it Anyway after this mishap it worked fine for another weeks and then suddenly this week it s refusing to power up Its battery has been shot for a while can t hold a charge and I ve been using it with the battery out Why the sudden refusal to boot I took the whole thing apart---minus the little chip the power jack looks totally fine and cosmetically sound Put the whole thing back together taking care to check that plugs were snug---still no power Stuck in the crappy battery booted just fine and then shut itself down after like minutes How likely is it that it s the power jack which is broken And why did it take this long to crap out if it IS broken A new one of those silly jacks costs over on eBay so I want to make sure that it s the jack before I just up and buy one Of course if it s the AC adapter that s broken that would cost even more Bah Input nbsp

A:Replace the power jack or replace the adapter?

AND/OR inside the case the the jack is soldered directly to the motherboard. Is also possible that
1) It's already cracked
2) If not yet, it's gonna crack

So look to see what connection looks like between power jack and motherboard, If you feel u wanna/can re-solder yourself or the typically price to redo the whole power thing seems to run $125 parts/labor/warranty if you take it somewhere. So how much is it all worth to you?
 

http://www.techspot.com/community/topics/replace-the-power-jack-or-replace-the-adapter.121170/
Relevancy 83.42%

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.

http://www.bleepingcomputer.com/forums/t/49444/outlook-express-editfindfind-and-replace/
Relevancy 83.42%

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?

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.

http://www.sevenforums.com/microsoft-office/167295-word-document-find-replace-find-duplicates.html
Relevancy 82.56%

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?

http://www.bleepingcomputer.com/forums/t/94988/find-replace/
Relevancy 82.56%

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.

http://www.bleepingcomputer.com/forums/t/204569/find-and-replace/
Relevancy 82.56%

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"?
 

Relevancy 82.56%

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.
 

https://forums.techguy.org/threads/find-and-replace.548739/
Relevancy 82.56%

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.

http://www.sevenforums.com/microsoft-office/133333-find-replace.html
Relevancy 82.56%

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.

http://en.community.dell.com/support-forums/desktop/f/3514/t/19996178
Relevancy 81.7%

For some reason W7 has decided to change 'Copy and Replace' with 'Move and Replace' when picking a file up with the left mouse and dragging it to another folder where an old version of the file exists.

My Excel SS is in two places: My desktop and USB which I use for backup. I would simply open the folder on the USB pick up the file on the desktop with the left mouse and drag it to the USB folder. Then I would get the message 'Copy and Replace'.. But not anymore it's become 'Move and Replace'.

I know I can 'Copy and Replace' by holding down the Ctrl key but I dont want to.

It looks like there should be a simple answer

Can anyone help? I swear I didnt change anything.

A:How can I 'Copy and Replace' not 'Move and Replace'.

Hi,
Have you ever tried right click drag and drop ?
There will be a list option after you drop,
Cheers.

http://www.sevenforums.com/general-discussion/334529-how-can-i-copy-replace-not-move-replace.html
Relevancy 81.7%

Hi all,

i was wondering if is it possible to create a macro to find and replace all fonts on a word document but don't apply that replacement to specific font

for ex.

select all text on file and make it (Arial) but don't apply that to text who takes (Symbol) font name

Thanks

http://www.techsupportforum.com/forums/f57/find-replace-fonts-1112121.html
Relevancy 81.7%

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 ???
 

https://forums.techguy.org/threads/find-and-replace-in-word-need-help.821266/
Relevancy 81.7%

Is there a program available that will allow a person to find and replace entries in the registry.

Yes, I am aware of the issues regarding making changes in the registry. However, my external hard drive failed and I need to change all entries related to the external hard drive in order to reinstall many of the programs that were on it.

Microsoft will not install anything because G:/ drive is invalid. Adobe will not install for the same reason. Many of my other programs look for the G: drive and stop installing when it is not found.

Thank you. If this is the wrong forum, please move.

Catherine

A:Find and Replace in Registry

You can use the built in registry editer. Start -> run -> regedit. Before making any changes be sure to back up your registry.

http://www.bleepingcomputer.com/forums/t/180068/find-and-replace-in-registry/
Relevancy 81.7%

Hi!
I would need an excel macro for mac to do this:

Search Column C for cell(s) containing the content of B1 and then replace all instances of B1 (located in Column C) with the content of Cell A1. and so on, and so on.

Preferably I would have the B and C column in a different sheet or workbook.

Hope that anyone can help. Thanks.
 

Relevancy 81.7%

Hello there,
I work with Excel 2007 and have a problem:
I have a spreadsheet with data scattered all over. I need the email adresses that are on this spreadsheet in a list. When I do the Find and Replace and search for the @ sign, it shows me all the search results in a new window. How do I copy that list and paste it in, say, another spreadsheet ? We are talking about 1944 email adresses! I am already done with my nerves at this point and I need help badly! Thank you in advance!
Susanne
 

A:Excel find and replace

Hi Susevienna. Welcome to the forum.

I think your best bet here would be to use Advanced filter.

Sort & Filter > Advanced

For your list range: Select your data
Criteria Range: Create heading(s), which matches that where your email addresses sit under. Multiple headings if required. Under which, put in "*@*" without the quotes.

You can select 'copy to new location' and select the new location to which you'd like your list to go.

Hope this makes sense.
 

https://forums.techguy.org/threads/excel-find-and-replace.847032/
Relevancy 81.7%

Can you please help me with what the wildcard string would be to delete anything that comes in parenthesis? Please? I need it badly!
 

Relevancy 81.7%

Hello guys, I'm new here and I want to ask you if you could help me. I have a text where there is some times a number apears n the form [*], where the asterisk is some number. I would like to replace all these forms by <a href="../Text/0001.xhtml#R*">[*]</a> (the number appears twice),for all the possibilities where a number apear in that form. I did it in Word, but it was not possible to replace, the Word just pasted [*], with the asterisk in the place of the number (the program was able to find the form, but not replace it). I could do it manually but I would spend a lot of time.Thanx anyone!

A:FInd and Replace option!

I use Bulk Rename Utility - This may assist you.
 
http://www.bulkrenameutility.co.uk/Screenshots.php
 
Slight learn curve - read help files etc.

http://www.bleepingcomputer.com/forums/t/599105/find-and-replace-option/
Relevancy 81.7%

I recently did a change of the Computer Name Control Panel - System - Computer Name - Change shortly after setting up a new XP Registry Find-and-Replace in XP Pro machine and am concerned over the fact that Find-and-Replace in XP Registry I still see many instances of the old name in the Registry I am now seeing where that may actually be posing a problem too Norton Anti-Virus is supposed to use the item in XP's Scheduled Tasks to scan drive C once a week but I noticed that since that name change it stopped working When I look in the properties of the Scheduled Task it has in the field for quot Run as quot the string oldcomputername Administrator quot When I try to change it to the new computer name it lets me edit it but as soon as I hit OK or Apply it goes right back to the old entry I've even tried deleting Find-and-Replace in XP Registry the Task and creating a brand new one using Norton's interface yet it still comes up with the old computer name there I'm not really sure where that's being kept but I assume it's in the Registry For this reason and as a general maintenance step I want to go through the Registry and do a global Find-and-Replace to change all instances of the old computer name Find-and-Replace in XP Registry to the new one Is that even advisable in the first place and if so what utility would I want to use Thanks

A:Find-and-Replace in XP Registry

Change who Windows is Registered to, follow these directions. Hope this helps.


HTML Code:
http://www.theeldergeek.com/modify_registered_owner_and_organization.htm

http://www.techsupportforum.com/forums/f10/find-and-replace-in-xp-registry-47815.html
Relevancy 81.7%

Hi there,

I'm trying to wriet a macro that includes a find replace, but i need to increment part of what is being searched for.
ie:
Sheet called DAY2 references DAY1
Sheet called DAY3 references DAY2

I want to have a find replace that will do something like below:

-------------------------------
Sub FindReplace()

x = Sheets.Count
Sheets(x).Select
Cells.Replace What:="DAY(x-1)!", Replacement:="DAY(x)!", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=True
End Sub
-------------------------------

Not sure of the right syntax to use,
Many thanks,
Riebe
 

A:Excel Find Replace

I'm definitely not an Excel expert, but I can tell you that if the answer is out there, then it can be found at www.MrExcel.com. The most complete Excel site I've seen. He's gotten a little commercial, but wade through that and you will find a great Excel reference.
 

https://forums.techguy.org/threads/excel-find-replace.653041/
Relevancy 81.7%

In Excel how do I write a macro that would look for a string in an entire column If the string is found it will copy the value to the next column in that same file For example In column A Have this adtr lt JCNECHMCBDISA and I want to look just for the MC and MC MNDJ if it found the MC in column replace with MNDJ if it s possible in the same row next column Its not always MC or that size it s a mass scale search and replace I have tried an if but didn t work and then I try recording a macro but I need Macro Find Replace & Help help because it replace times because sometimes the replacements have the exact word that I m also looking for Example Selection Replace What quot TIPOLEIJ quot Replacement quot POL- LIN MC DS quot LookAt xlPart SearchOrder xlByRows MatchCase False SearchFormat False ReplaceFormat False Selection Replace What quot MC quot Replacement quot MNDJ quot LookAt xlPart SearchOrder xlByRows Find & Replace Macro Help MatchCase False SearchFormat False ReplaceFormat False When it search for the word TIPOLEIJ it replace with POL- LIN MC DS quot but when it search for MC it change the TIPOLEIJ replacement to POL- LIN MNDJ DS Im wondering if Find & Replace Macro Help there is something that after it replace the value lock the cell so its not replace again Hope someone can help Thanks nbsp

A:Find & Replace Macro Help

Can you post a sample workbook?

Rollin
 

https://forums.techguy.org/threads/find-replace-macro-help.935610/
Relevancy 81.7%

Just cloned an ailing - and need replace to find Registry drive for a customer The new Registry - need to find and replace drive works fine - no problem Just one small Registry - need to find and replace issue My customer had originally bought his PC second-hand and he d like to remove all traces of the previous owner s name from the new hard drive My question Is there a registry app that makes a simple job of finding and replacing all registry instances of say George with Harold Obviously I can do this manually and have done in the past But it was a tedious job If such an app exists as I ve described above I d like to know about it -- Thanks in anticipation PS - It would be helpful Registry - need to find and replace if you re able to suggest something that you KNOW works rather than an app that you haven t personally tried I say this because there are several progs such as New Owner which purport to change the owner s name but in actuality only change a few instances of the entry instead of ALL nbsp

Relevancy 81.7%

Hey need help!!

I have a ton of formulas that I need to replace the row reference! for example:

J21+J50+J87+J90+J106,J21+J50+J87+J90+J106,J21+J50+J87+J90+J106 (30 needs to be 50,50 to 86, so on)
next line would be the exact same as this:
J21+J50+J87+J90+J106,J21+J50+J87+J90+J106,J21+J50+J87+J90+J106
But different replacement numbers

i can insert the numbers that I would like replaced into the columns next to the formulas if that helps!

PLEASE HELP!!!
 

A:Macro for Find/Replace

Hi, welcome to the forum.
I suggest you mention the version of Excel you're using too.
If you can place the numbers yourself, you can also a find and replace ...
 

https://forums.techguy.org/threads/macro-for-find-replace.1101433/
Relevancy 81.7%

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?
 

https://forums.techguy.org/threads/query-that-does-what-im-doing-with-find-and-replace.400622/
Relevancy 81.7%

Hi all... I am working with a MS Word 2000 document that has a huge batch of numbers involved. The problem is that some of the numbers have run together... e.g.:

439 441 442 443 444445 449 450 452 454 458 459 460 461 462 463 464 468 470 472 473 474 477 479480

I can identify these errors just fine by searching for ^#^#^#^#^#... five digits in a row. Is there any way of doing a replace, using the same digits but with a space entered in after the first three? Right now I'm changing it by hand and have already spent nearly three hours engaged in this tedium. Any advice would be wonderful! Thanks.... Jim
 

A:Find & Replace question...

Are your 3 (or erroneous 6)digit numbers in seperate cells?
If so, you could do something like this:

I entered a list of 3 digit numbers and a few 6 digit numbers in cells A1 to A10. In B1, I entered:
=IF(A1>99999, LEFT(A1,3)&" "&RIGHT(A1,3),A1)
and then copied the formula down to B10.

In other words, if the value in the cell is a 6 digit number, show the 3 characters on the left, followed by a space, followed by the 3 characters on the right.

Alternatively, you could put the LEFT and RIGHT formula in adjacent cells, so that you only have 3 digit numbers in each resulting cell:

In B1, enter:
=LEFT(A1,3)

And in C1, enter:
=IF(A1>99999,RIGHT(A1,3),"")

You can then copy the resulting data and Paste Special > Values into another worksheet or workbook.

HTH

Gram
 

https://forums.techguy.org/threads/find-replace-question.253279/
Relevancy 81.7%

I recently did a change of the Computer Name Control Panel - System - Computer Name - Change shortly after setting up a new XP Pro machine and am concerned over the fact that I still see many instances of the old name in the Registry I am now seeing where that may actually be posing a problem too Norton Anti-Virus is supposed to use the item in XP s Scheduled Tasks to scan drive C once a week but I noticed that since that name change it stopped working When I look in the properties of the Scheduled Task it has in the Find-and-Replace Registry XP in field for quot Run as quot the string oldcomputername Administrator quot When I try to change it to the new computer name it lets me edit it but as soon as I hit OK or Apply it goes right back to the old entry I ve even tried deleting the Task and creating a brand new one using Norton s interface yet it still comes up with the old computer name there I m not really sure where that s being kept but I assume it s in the Registry For this reason and as a general maintenance step I want to go through the Registry and do a global Find-and-Replace to change all instances of the old Find-and-Replace in XP Registry computer name to the new one Is that even advisable in the first place and if so what utility would I want to use Thanks nbsp

A:Find-and-Replace in XP Registry

I don't know of any Windows Supplied utilities. FWIW, I've never bothered to search out the old names when I change a computer name. I have seen that you need to fix the scheduled tasks, but I don't know of any other issues that arise...
 

https://forums.techguy.org/threads/find-and-replace-in-xp-registry.350407/
Relevancy 81.27%

I have large text files with long (paragraph length) lines. I was wondering if there is a simple software utility (within Windows XP, Lotus SmartSuite, or elsewhere) that can convert all lines in the file to a set maximum character length (say 80) then restore to original length lines as needed. I am talking about inserting a CR/LF at the end of each new line with one utility, and removing only the added ones with the other utility. I used to have two simple compiled Pascal functions which did this in DOS, but those are long gone. Thanks for your help.
 

Relevancy 80.84%

Hi I am complete noob but need some help ASAP not sure if this is correct forum Basically I have an xml file which I need to edit see below the are just editted data so work dont complain lt ORDERS gt lt ORDER gt lt ORDER ID gt lt ORDER ID gt lt ORDER DATE gt - - lt ORDER DATE gt lt ORDER TYPE gt STD lt ORDER TYPE gt lt CREDIT CARD NUMBER gt lt CREDIT CARD NUMBER gt and macro replace find Excel lt DESPATCH NOTE gt lt BRAND gt GB lt BRAND gt Excel find and replace macro lt Excel find and replace macro DESPATCH NOTE gt lt RECIPIENT gt lt NAME gt lt CDATA gt lt NAME gt lt EMAIL gt lt EMAIL gt lt ADDRESS gt lt ADDRESS LINE gt lt CDATA The gt lt ADDRESS LINE Excel find and replace macro gt lt ADDRESS LINE gt lt CDATA Head Yard gt lt ADDRESS LINE gt lt ADDRESS LINE gt lt CDATA gt lt ADDRESS LINE gt lt TOWN gt lt CDATA FURNESS gt lt TOWN gt lt COUNTY gt lt CDATA gt lt COUNTY gt lt POSTCODE gt lt CDATA HF gt lt POSTCODE gt lt COUNTRY gt GB lt COUNTRY gt lt ADDRESS gt lt RECIPIENT gt lt GIFT MESSAGE gt lt GIFT MESSAGE LINE gt lt CDATA gt lt GIFT MESSAGE LINE gt lt GIFT MESSAGE LINE gt lt CDATA gt lt GIFT MESSAGE LINE gt lt GIFT MESSAGE LINE gt lt CDATA gt lt GIFT MESSAGE LINE gt lt GIFT MESSAGE gt lt DELIVERY LINE gt lt ORDER LINE ID gt lt ORDER LINE ID gt lt SKU gt lt SKU gt lt QUANTITY gt lt QUANTITY gt lt UNIT PRICE CURRENCY quot GBP quot gt lt VALUE gt lt VALUE gt lt UNIT PRICE gt lt DISCOUNT PRICE CURRENCY quot GBP quot gt lt VALUE gt lt VALUE gt lt DISCOUNT PRICE gt lt DELIVERY LINE gt lt ORDER LINE gt lt ORDER LINE ID gt lt ORDER LINE ID gt lt SKU gt lt SKU gt lt QUANTITY gt lt QUANTITY gt lt DESCRIPTION gt lt CDATA gt lt DESCRIPTION gt lt UNIT PRICE CURRENCY quot GBP quot gt lt VALUE gt lt VALUE gt lt UNIT PRICE gt lt DISCOUNT PRICE CURRENCY quot GBP quot gt lt VALUE gt lt VALUE gt lt DISCOUNT PRICE gt lt ORDER LINE gt Click to expand Ok so that is the XML file it will have this reoccuring for all the orders within that file Everytime it says lt ORDER LINE ID gt lt ORDER LINE ID gt lt SKU gt lt SKU gt Click to expand I want to replace the numbers between lt SKU gt lt SKU gt with another SKU from a list E G Find lt ORDER LINE ID gt lt ORDER LINE ID gt lt SKU gt lt SKU gt Click to expand Replace lt ORDER LINE ID gt lt ORDER LINE ID gt lt SKU gt lt SKU gt Click to expand The only reason I am struggling is because lt SKU gt lt SKU gt occurs beneath lt DELIVERY LINE gt lt ORDER LINE ID gt lt ORDER LINE ID gt Click to expand I dont want to alter this SKU as it is the DELIVERY SKU I only wish to adjust the ITEM SKU SKU above lt DESCRIPTION gt lt So find and replace with a RANDOM SKU from a LIST E G etc etc I can copy the data stored in an XML file and just past into a single column in Excel Is this possible And if so would anyone mind showing THANKS in ADVANCE nbsp

A:Excel find and replace macro

Hi there, welcome to the board!

Do you have the xml file you can share/upload? I'm not really sure I understand why, but I think I understand how you want to do this. You just want a random number on the Item SKU, is that right? Then what, save it as a different file?
 

https://forums.techguy.org/threads/excel-find-and-replace-macro.1061252/
Relevancy 80.84%

What I need to do is probably simple but I m not really into VB It is this I want to hardcode find and replace text in an XML document about different VB6 file in replace find and external replacements These will be the same every time and the document will always be at c xxx yyy xml So for example the XML document contains something like lt Name gt lt Forename gt John lt Forename gt lt Surname gt Smith lt Surname gt lt Name gt lt Name gt lt Forename gt Peter lt Forename gt lt Surname gt Jones lt Surname gt lt Name gt I VB6 find and replace in external file want to find and replace every lt Forename gt with lt Forename ID gt every lt Surname gt with lt Surname ID gt etc etc and I will want to do this regularly the same replacements every time There are lots of find and replace utilities but I would have to type in my find and replace criteria manually every time What I d like to do is create a small EXE to do the job with the find and replace strings coded in Can anyone point me in the right direction please TIA nbsp

Relevancy 80.84%

I've inherited a spreadsheet with text entered in the first column. Some of the names are followed by * or # to designate cross reference info. I want to take these out because the designations were good for 2004 but are not correct for 2005. When I do a search and replace, it deletes all the information in the column instead of just the * or the #. How do I do this without manually going into every entry?
 

A:Excel find and replace feature

Select your range of cells that you want to evaluate and run this macro:
Code:
Public Sub Replace()

vChar = InputBox("ENTER CHARACTER TO DELETE")

For Each vCell In Selection.Cells

If InStr(1, vCell, vChar) > 0 Then

vCell.Value = VBA.Replace(vCell, vChar, "")

End If

Next

End Sub
Rollin
 

https://forums.techguy.org/threads/excel-find-and-replace-feature.331425/
Relevancy 80.84%

Hi guys,

In my Excel 2010 workbook there is a cell with the value of "90" in type of number/general. When I go to find and replace dialog box and try to find the number "90" by typing it in Find what rectangle, then I want the program looks for it in formulas (look in: Formulas). But it shows that "90" as the result! Why? I said it to look for it in Formulas not in values.
 

http://www.techspot.com/community/topics/excel-2010-find-replace.202268/
Relevancy 80.84%

Hi everybody, I have an issue with my AIO HP Pavilion 22-H010EL TouchSmart.The hard drive broke twice while PC was covered by warranty; now the warranty period is over, and the hard drive broke again. I suppose there's a power supply issue, in fact I see the hard drive has more boots up than I actually did; sometimes I can clearly hear a boot up noise while the PC is on (and I'm sure it's not because of the stand-by, since it happens while I'm using it). Also, just after the first hard drive replacement, it shown 7 boots up in just a hour; I suppose the SATA/Power Cable is damaged, causing the issue described, but it could be the motherboard, too.I'd like to replace the cable to see if it works, I really hope it does; thank you in advance for any reply.

http://h30434.www3.hp.com/t5/Desktop-Hardware-and-Upgrade-Questions/Need-to-replace-the-SATA-cable-in-my-AIO-can-t-find-the/td-p/5796024
Relevancy 80.84%

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.
 

https://forums.techguy.org/threads/word-macro-find-and-replace.279192/
Relevancy 80.84%

okay here it comes. I need to find a way to find replace data on a big scale for excel 2003. I have a bunch of numbers(5m or so) that correspond to a different number. I don't know how to write a macro at all, and am currently find replacing, but this seems like it's going to take a life time.

Example:
Worksheet1
1____________ 10000
2____________ 93233
3____________ 43234

Worksheet 2 parenthesis is a cell
(1) (2) (2) (1) (3) (2)
(2) (1) (2) (3) (2) (3) etc.

I need to make worksheet 2 numbers change to represent the numbers corresponding to worksheet 1 so for every (1) that comes up it changes to 10000. I hope I explained this right. Please Help, I will continue find replacing while I hope for an answer.
 

A:Odd Find Replace Excel God Needed :)

The simplest and quickest way is to use built-in Excel functions.
You will need a 3rd worksheet for metadata. Not knowing the actual sheet names, I'll assume they are called

Sheet1
Sheet2
Sheet3
Also, let's say Sheet1 has the data in columns A & B, and data in Sheet2 begins at cell A1
So, in Sheet3, in cell A1 you will need this formula:

Code:
=VLOOKUP(Sheet2!A1,Sheet1!A:B,2,FALSE)
Extend the formula for as many cells as you have in Sheet2.
When ready, click on the upper left corner of Sheet3 to select all cells (i.e. the whole worksheet), press Ctrl+C, then from menu select Edit -> Paste Special -> Values.
As a result, you will have the desired numbers in Sheet3. You can then copy them to Sheet2, if you wish.

Jimmy

Edit:
I have assumed that 1____________ 10000 in your post means 1 in column A and 10000 in column B.
If 1____________ 10000 is in a single cell, then the above formula will not work, another one, a more complicated one will need to be used. I'll wait for you feedback before working it out.
 

https://forums.techguy.org/threads/odd-find-replace-excel-god-needed.1019975/
Relevancy 80.84%

Given:
I have a "Data" Sheet with Raw Data
Column A has item number, Column B has Qty
I Have a "Result" Sheet with cells i want to update
Column R has same item number, Column S has Qty(that needs to be updated)

Here is what I want to accomplish with VBA:

Select Sheet "Data"
X= Cell A1, Y= Cell B1
Select Sheet "Result"
Find X
Replace the next cell to the right with Y
Find Next Occurrence and replace again (if it exists), If not:
Select Sheet "Data"
X = Cell A2, Y=B2

(repeat the find and replace routine)
If Sheet "Data" Next item in the list (ex A1000) does not contain data, quit. ​
 

Relevancy 80.84%

Hello Everyone,

Could you please help me for write macro for replacing new name in dynamic way. A column's data should replace with g column's data, macro should find data in A column's and replace with g cells entire data. please find i have attached text excel sheet.

thanks in advance.
Saleem
 

Relevancy 80.84%

Do to hacking Need html software find and replace problems because of old web hosting not updating the hosting software we my company is having to do large find and replace of text on the Need software find and replace html code parts of html Need software find and replace html pages Instead of having to open each html Need software find and replace html web page and do a find and replace in FrontPage Is there a way to do a find and replace on several pages or a whole folder at once Any software that will do that Example Can I have any type of software that will search a fold with html files it for example only Use find the word dog in the codes and replace with word cat in all pages in the folder Opening the over html web page we have doing a find and replace on the codes is going to take forever and I am looking for a way to speed that up Many of these web page where build back in last s when we were still all hand coding html and when frames was exciting new stuff So there is not content manager being used Thank you for your time and any suggestions Kimber nbsp

A:Need software find and replace html

The fact that it is HTML is irrelevant if you have the source. It is just TEXT

Many text editors and search programs will do what you want.
 

https://forums.techguy.org/threads/need-software-find-and-replace-html.644318/
Relevancy 80.84%

Hi there I have a very straightforward problem and want the simplest way of getting around it I have a list of two lists of schools each with a unique identifier The first list contains some schools that have incorrect identifiers in amongst schools that have the correct code The second has the school with both the incorrect and correct identifier I need to find the incorrect identifiers in the first list and replace them with their correct identifier as in the second list Apart from the identifier I also have the school s name which should be identical A graphic example Sheet SchoolCode SchoolName JS Primary - correct PP School - incorrect KK School - incorrect - find macros! replace new and Mass to HU School - correct Pdf high Mass find and replace - new to macros! - incorrect etc with the distribution of correct vs incorrect in no particular order Sheet SchoolCode incorrect SchoolName SchoolCode Correct JS Primary KK School Pdf high Is there a macro or some other way of finding and replacing the incorrect codes in sheet with the correct ones in sheet Thanks so much Z nbsp

A:Mass find and replace - new to macros!

Once you have made the choice,
you can store the incorrect value in one variable and the correct one in another one.

With vba you can use the replace() function

The syntax is replace(<complete textline>,<value to search for>,<value to replace with>)

So if you are in a cell
you could say activecell.value = replace(activecell.value,"wrong","corrected")

See if this helps, may sound strange but try it on a simple line of texct and see
 

https://forums.techguy.org/threads/mass-find-and-replace-new-to-macros.965820/
Relevancy 80.84%

Hi,

A file contains path as
var=C:\....\....\\...\\....
I want to write a batch script which can find single '\' in particular file and replace it with '\\'
Can anyone help me with this ??
 

https://forums.techguy.org/threads/want-batch-script-for-find-and-replace.629826/
Relevancy 80.84%

Hi, im using the model specified above and i need to replace my dvd drive with a hdd caddy but i cant figure out which size my dvd drive is and which model to replace it with. This is my laptop model http://www.cnet.com/products/hp-pavilion-15-p030nr-beats-special-edition-15-6-a-series-a8-5545m-wind... And this is the hdd caddy which i'm planning on getting http://www.lelong.com.my/sata-3-2-5-laptop-ssd-hdd-caddy-harddisk-hard-disk-optical-drive-bay-oleole... It comes in two different sizes, the 12.7mm version and a smaller 9.5mm one.. Please help.. Regards,Afrodin

http://h30434.www3.hp.com/t5/Notebook-Hardware-and-Upgrade-Questions/Need-to-find-out-size-of-dvd-drive-to-replace-it/td-p/5656871
Relevancy 80.84%

I have written Macro Find/Replace MS Word a macro in MS Word that basically checks items off Find/Replace MS Word Macro 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 To Find and replace times SearchTerm InputBox quot Word to search quot 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 nbsp

https://forums.techguy.org/threads/find-replace-ms-word-macro.699974/
Relevancy 80.84%

Hi guys,

In my Excel 2010 workbook there is a cell with the value of "90" in type of number/general. When I go to find and replace dialog box and try to find the number "90" by typing it in Find what rectangle, then I want the program looks for it in formulas (look in: Formulas). But it shows that "90" as the result! Why? I said it to look for it in Formulas not in values.

A:Excel 2010, find & replace

If I understand you correctly, the 90 is a value computed from a formula in that cell.

You should search for 90 as a value if you want to find that cell.

Searching for 90 in a formula would mean that you are searching for the number "90" somewhere within a formula, not within a cell value.

If the formula in that cell was =110-90, I would expect that a search for 90 in formulas would find that cell.

If the formula in that cell was =110-20, I would not expect that a search for 90 in formulas would find that cell. A search for 90 in values would find it.

If the formula in that cell was =110-90+70, I'd expect that cell to be found by both searching for value or searching in formulas because 90 is the value of that cell and 90 is also found in the formula.

http://www.sevenforums.com/microsoft-office/330913-excel-2010-find-replace.html
Relevancy 80.84%

I need to erase all instances of lines like:

BOB TO ROSE)

ROSE TO BOB)

PETER TO ROBERT)

What's the wild card I have to use to have them all erased without erasing all the caps from the rest of the document which are in regular sentence case....

Can you please help me? I can't figure it out!
 

Relevancy 80.84%

Geeks hey there,

I was just going through this forum and found that my problem can be solved here

I have 2 columns in excel A & B I want to find all my data of Column B in Column A and Replace it with "" nothing.

Please guide me accordingly will be very grateful for your help because they are more than 6000 rows and finding and replacing will just take hell of time. I have also attached a sample file.

I want to find all data of Column B in Column and want to replace with nothing ""

Thanks.
 

A:Multiple Find and Replace in Excel

Hi
Try this solution. In column C enter this formula;
=REPLACE(A1,FIND(B1,A1),LEN(B1)+1,"")
and copy it down the length of the data. If the result is as you want it you can then copy the entire column and pastespecial/values into column A if you want to overwrite that data. See the attached for how the formula works.
 

https://forums.techguy.org/threads/multiple-find-and-replace-in-excel.1129560/
Relevancy 80.84%

Hi

I wonder if anyone would know how to replace the last occurance of a character within a cell.

For example replace the last comma of the below with and

i.e. myString = String1, String2, String3, String4

myStringWouldThen = String1, String2, String3 and String 4

Thanks
 

A:Excel - Find and replace the right most comma

Hi MattMurphy

It shoul be for Excel, Word, or?...
 

https://forums.techguy.org/threads/excel-find-and-replace-the-right-most-comma.635960/
Relevancy 80.84%

Is there any way to search and replace a term in an entire directory?

For example, I am working on getting my organization's new website ready to go live and there are tons of text changes that I need to propogate across the site. I am in the root directory (standupnew), and it has about 80 subfolders, most of them for the various programs we have. I want to be able to click on the standupnew folder and have it search all the subfolders for "StandUP" and change it to "StandUp". Is this possible?

A:Dreamweaver CS4 Find and Replace question

Here's a tutorial on the function:
Using Dreamweaver's Find & Replace Command - OIT - UMass Amherst

Another:
http://help.adobe.com/en_US/Dreamwea...f21-7cc7a.html

http://www.sevenforums.com/software/78102-dreamweaver-cs4-find-replace-question.html
Relevancy 80.84%

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 VB Macro Word MS Find/Replace in if this is the most efficient way of doing it but this is the way Find/Replace Macro in MS Word VB I ve come up with What I would like Find/Replace Macro in MS Word VB to add to it is the ability to have it tell me when the term is not found in the list and possibly add Find/Replace Macro in MS Word VB 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 To Find and replace times SearchTerm InputBox quot Word to search quot 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 nbsp

https://forums.techguy.org/threads/find-replace-macro-in-ms-word-vb.699993/
Relevancy 80.41%

I am working on a system and have run into a problem outside my normal area I have a system that reads text files and makes a report This runs on a server that is old We are working to move the system to a server running a current version of server software Everything seems to work with one major problem The host system a mainframe sends the data as a print file The existing system captures the print stream and puts it into a text file Printing file to utility a text The text files are automatically named with a sequence number There are multiple files created with one piece of data to be processed in each file The Printing to a text file utility new server is not creating the files from the printer stream The software is identical but the change to the new server has broken something I have set up a text file to capture the data but it rejects the connection according to the Printing to a text file utility mainframe log What I am looking for is how to set the printer up on Windows server bit version I have Blue Zone and can consider other software The older version of this used Reflections as a printer emulator nbsp

https://forums.techguy.org/threads/printing-to-a-text-file-utility.1037305/
Relevancy 79.98%

Tech Support Guy System Info Utility version OS Version Microsoft Windows Find/Replace issues, MS Word 2010 bit Processor Intel R Core TM i - M CPU GHz Intel Family Model Stepping Processor Count RAM Mb Graphics Card Intel R HD Graphics Mb Hard Drives C Total - MB Free - Find/Replace issues, MS Word 2010 MB Motherboard Gateway VG HC CR Antivirus McAfee Anti-Virus and Anti-Spyware Updated and Enabled I am using find replace to find double spaces between my Find/Replace issues, MS Word 2010 sentences and replace them with single spaces in MS Word 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 nbsp

https://forums.techguy.org/threads/find-replace-issues-ms-word-2010.1082102/
Relevancy 79.98%

i would like to do the reverse of the attached macro

i would like to find and replace info in coumn c with the value of column b

column a=b

http://forums.techguy.org/business-applications/1032256-solved-macro-multiple-find-replace.html#post8195167
 

A:Solved: Excel Macro find and replace

The macro I wrote for you put the value from Column A which corresponds to the value in Column B in Column C
What do you exactly need?
If you want the value in Column B to replace the value in Column C then the result is the same as the source.
At least if I edit the macro to do that that is what happens.

below the original macro

Code:

Sub YourQuestion()
Dim rng As Range, rng2 As Range
Dim rVal As Integer

For Each rng In Range("B2:B" & WorksheetFunction.Max(2, Range("B" & Rows.Count).End(xlUp).Row))
rVal = rng.Offest(0,-1).Value
Columns("C:C").Select
Selection.Replace What:=rng.Value, Replacement:=rVal, LookAt:= _
xlWhole, SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:=False, _
ReplaceFormat:=False
Next rng
Range("A2").Select
End Sub

the changed macro

Code:

Sub YourQuestion()
Dim rng As Range, rng2 As Range
Dim rVal As [COLOR="Red"]Variant[/COLOR]
For Each rng In Range("B2:B" & WorksheetFunction.Max(2, Range("B" & Rows.Count).End(xlUp).Row))
rVal =[COLOR="red"] rng.Value[/COLOR]
Columns("C:C").Select
Selection.Replace What:=rng.Value, Replacement:=rVal, LookAt:= _
xlWhole, SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:=False, _
ReplaceFormat:=False
Next rng
Range("A2").Select
End Sub

I don't see the point of this but you're the one asking.
 

https://forums.techguy.org/threads/solved-excel-macro-find-and-replace.1043099/
Relevancy 79.98%

I am in need to a macro that replaces a range to cell address with another for the entire worksheet. For example, $5451 with $401 and $5452 with $402, etc. I am new to macros. Any help will be appreciated. Thank you!
 

A:Macro to Find/ Replace a Range of Values

Try something like this:
Code:

Sub FandReplace()
Dim cell1 As Range, AllCells As Range
Range("A1").Select
Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
For Each cell1 In Selection
If cell1.Value = "$5451" Then cell1.Value = "$401"
Next
Range("A1").Activate
End Sub
 

https://forums.techguy.org/threads/macro-to-find-replace-a-range-of-values.937585/
Relevancy 79.98%

ok, here is my situation, I have 2 lists, one is a list of numbers, and the other is a random document with lets say the word sale in it.

I'm looking for a program or a way, batch file or w/e, command, or anything at all to do this.

I need to replace every instance of the word sale in one document, with a number from the list
for example
If this is the list of numbers

45
67Click to expand...

and this is the document

I had one for sale, and I had another for sale.
Click to expand...

the end result would need to be

I had one for 45, and I had another for 67.Click to expand...

thats it

(Also to the admins, if there is a better section this can be put in, please move it, this is the only one I could find that seemed appropriate.)
 

Relevancy 79.98%

Hay,
I have a problem
In Colum A I have sentences in lower case letters
I need to replace only part of the sentence to upper case because it consist names
I have a list of the names in the proper letters in sheet 2 Colum A
I have more than 30,000 sentences to replace
Help!!!​
Example : ​
Sheet 1 Colum A​
The art of jean arp
Great masters of world painting: botticelli, canaletto, watteau, cezanne, titian.
The drawings of paul cezanne :a catalogue raisonne

Sheet 2 Colum A

Jean
Paul
Botticelli,
Watteau,
Cezanne,
Titian
Arp
Canaletto

I need to change colum A in this order

The art of Jean Arp ​Great masters of world painting: Botticelli, Canaletto, Watteau, Cezanne, Titian
The drawings of Paul Cezanne :a catalogue raisonne

Thanks
Efrat


 

A:Multiple Find and Replace in Excel 2007

Any expert can comment why

For Each rng In find_source

fails and .cells is needed.

Am using excel 2010 btw.
 

https://forums.techguy.org/threads/multiple-find-and-replace-in-excel-2007.1057567/
Relevancy 79.98%

Hello,

I currently have a text file with a list of email address which I need to send to our tech guy. He wants this list in a specific format as follows...

arrEmail(1)=&#8220;[email protected]&#8221;
arrEmail(2)=&#8220;[email protected]&#8221;
arrEmail(3)=&#8220;[email protected]&#8221;

Using "Find and Replace" I now have the following...

arrEmail(x)=&#8220;[email protected]&#8221;
arrEmail(x)=&#8220;[email protected]&#8221;
arrEmail(x)=&#8220;[email protected]&#8221;

All I need now is to replace the x with the consecutive numbers (there is actually over 600 in the list and this is not a one off job so would prefere not to have to manually change them)
Any ideas?
TIA
 

Relevancy 79.98%

I have a hp pavilon  all in one  64 bits windows 10. I ran a test everything passed except the short DST   also  a message said shadow copy service not working. so I try to replace the hard drive   it want find the new hard drive and it good  because I try it in another computer .The hard drive that come with the computer is a wd 500   I'm try to  replace it with  seagate 250 gb  They have same connection and it connect good I see no reason why it doesn't accept it. It also has windows 10 on itThanks  for any help 

http://h30434.www3.hp.com/t5/Desktop-Hardware-and-Upgrade-Questions/replace-hard-drive-bios-can-t-find-it/td-p/5676126
Relevancy 79.98%

Hi, recently I got a problem with my laptop Screen which needs to be replaced. Please help me out in finding part and model number. Thanks.

A:How to find type of laptop screen to replace

KishoreKandula Hello;Allow me to welcome you to the HP forums!I read your post about needing to replace the screen on your and wanted to help. The screen is part of something known as the Display Assembly.Information on that starts on page 103 of your Maintenance and Service Guide: http://h10032.www1.hp.com/ctg/Manual/c02842252 If you can find your specific model number, you can use this tool to get a list of parts:  HP PartSurfer You can order HP parts from here: The HP Parts Store | HP Computer Parts | HP Printer PartsGood Luck========================================================================I am a volunteer and I do not work for, nor do I represent, HP.---------------------------------------------------------------Please click "Accept As Solution" on the post that solves your issue to help others find the solution.Please click the Thumbs-Up symbol on the left of the Reply button to say thanks fopr my help.========================================================================

http://h30434.www3.hp.com/t5/Notebook-Video-Display-and-Touch/How-to-find-type-of-laptop-screen-to-replace/td-p/5590036
Relevancy 79.98%

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
 

https://forums.techguy.org/threads/solved-word-emergency-find-replace.827415/
Relevancy 79.98%

Hello, The hard drive in my computer has ceased to properly function. Thus, i want to replace it. However, since this is a pre-built computer, it seems that I am limited to the OS provided by you guys. The thing is that I can't find the recovery file on the website or a physical recovery disk on any other website.  Is the physical recovery disk still available for this computer? If not, are there any available alternatives? I understand that one such is purchasing a new OS, but that's a little too pricey, which I think doesn't justify sticking with the PC(it's 5 years old after all). So it would be preferable if the available alternatives aren't so expensive. Thank you.

http://h30434.www3.hp.com/t5/Desktop-Operating-Systems-and-Recovery/I-want-to-replace-old-hard-drive-but-can-t-find-recovery/td-p/5666267
Relevancy 79.98%

Hello. I am attempting to develop a macro that will allow me to find a number in column D and replace that value with a text name. I have 31 - 5 digit codes with 31 corresponding text names. The spread sheet is 10,000+ entries and growing every day. For example, I would like to find all instances of "21021" (in column D ONLY) and replace them with the word "Boyle." And so on, for all 31 codes. I'm new to Macros and could really use a little help to get me started!

Thanks!
 

Relevancy 79.98%

Hello Im sorry if i placed this in Macro, Excel + WMI Script replace Find the wrong thread but i thought since it has to do with excel this is the correct one Iam trying to write a script to get rid of the quot quot in a excel file i output the netview to Ive tried to inserting a macro for a find and replace with no such luck i was wondering what iam missing Im sure its possible if such a macro can be recorded Below is the code im using ive looked everywhere for a solution and googled for every string i thought i could get a solution from with no luck Below is the last one ive tired selecting the range from WMI Script + Excel Macro, Find replace A - A and search only with in this range no luck either Thanks in advance Tim email protected dim objXLapp objXLsheet dim strtemp dim nicset Set objShell CreateObject quot WScript Shell quot objShell run quot COMSPEC k net view findstr gt netview output xls quot Excel Application set objXLapp createobject quot excel application quot objXLapp visible true set objXLsheet objXLapp workbooks open quot c scripts netview output xls quot objXLsheet Range quot A A quot Select Selection Replace What quot quot Replacement quot quot quot quot LookAt xlPart SearchOrder xlByRows MatchCase False Saves ChDir quot C Scripts quot ActiveWorkbook SaveAs Filename quot C Scripts netview output xls quot FileFormat xlText CreateBackup False objXLapp quit set objXLapp Nothing nbsp

A:WMI Script + Excel Macro, Find replace

What application are you trying to run this code from? Are you trying to run this code directly in Excel or another application?

Rollin
 

https://forums.techguy.org/threads/wmi-script-excel-macro-find-replace.275703/
Relevancy 79.98%

Hello There I have ben trying to find out how I can use a and Excel Find - replace lists Solved: using list with two columns in Sheet to do find and replace in another sheet Sheet Basically I want to change the text in a list in Sheet based on text I Solved: Excel - Find and replace using lists have in the other list There are multiple values of the same text in my list Sheet and each needs to be changed to another unique text value I have been doing this in the past with multiple nested Solved: Excel - Find and replace using lists if statements but thought there might be a quicker easier way I have also realised that Excel won t nest if statements or will it My formula Solved: Excel - Find and replace using lists looks like this nested if s If quot Current Text quot quot List Text quot quot New Text quot If quot Current Text quot quot List Text quot quot New Text quot If quot Current Textn quot quot List Textn quot quot New Textn quot And My spreadsheets look like this Sheet Name Current Text Mr A Site Mr B Site Mr C Site Mr D Site Mr E Site Mr H Site Mr I Site Mr J Site Mr K Site Sheet List Text New Text Site New Site One Site New Site Two Site New Site Three Site New Site Four Site New Site Five I have tried to show the columns using spaces as I don t know how to format the text properly I Have also attached a spreadsheet showing the structure None of the text corresponds between the old and new names but there are a finite number of old site names that I need to change and all occurences of each old site name are the same ie always called quot Site quot etc In all cases every occurence of the name needs to be changed to the new text ie List Text always needs to be changed to New Text Also I am using Excel for Mac so won t be easily able to use VB scripts Thanks in advance for the help I hope I have managed to explain the problem clearly Random nbsp

A:Solved: Excel - Find and replace using lists

Well, after a bit of searching and asking around the office, I discovered the VLOOKUP function in Excel - does exactly what I am looking for!

What a fab program.
 

https://forums.techguy.org/threads/solved-excel-find-and-replace-using-lists.853047/
Relevancy 79.98%

I'm hoping to get lucky with this post since the forums on the official Notepad website are very expressions?? Notepad++ using find-replace function reg. without slow to respond Notepad++ using find-replace function without reg. expressions?? and Notepad++ using find-replace function without reg. expressions?? maybe someone on here uses NPP and knows the answer Say I want to find a certain block of code that spans across multiple lines and replace it with another block of code which spans across multiple lines as well From what I understand this is possible but you have to use regular expressions which means taking both blocks of code and manually editing them to replace all the line breaks with regular expressions so that they could fit into the single line input of the find-replace function Needless to say this is very tedious and time consuming Is there any way that I can just select and copy-paste a block of code spanning across multiple lines then replace it with another one which I copy-pasted as well without having to manually edit them to replace line breaks with regular expressions This was possible in CuteHTML which I was using before making the switch to Notepad I'm not sorry that I did as Notepad is far superior but that is the only feature from CuteHTML that I miss the ease with which you could find-replace large blocks of code just by copy pasting them Any help will be greatly appreciated Thanks for reading

A:Notepad++ using find-replace function without reg. expressions??

Seems pretty straight forward to me. Use "extended" mode for searching, copy the line in that you want replaced, replace the line breaks with "\r\n", then put the text in you want it replaced with and do the same.

http://www.sevenforums.com/software/189253-notepad-using-find-replace-function-without-reg-expressions.html
Relevancy 79.98%

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.
 

https://forums.techguy.org/threads/doubt-in-find-and-replace-option-in-ms-word.604265/
Relevancy 79.98%

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".
 

https://forums.techguy.org/threads/word-2007-find-and-replace-problem.1024210/
Relevancy 79.98%

I am trying to keep my database up to date, each month i have to manually find and replace 800 cells of address data.

is there a way that excel can find and replace the old data with the new

see attachment - new data in column h
removed attachment - only load dummy data -- etaf moderator >
 

A:find and replace multiple cells in excel

i have removed your spreadsheet - as i was not sure if it included only dummy data - it looked like valid names and addresses to me
please do NOT use real data here - on a public forum - see here
http://forums.techguy.org/business-applications/689922-do-not-post-attach-private.html
 

https://forums.techguy.org/threads/find-and-replace-multiple-cells-in-excel.1060237/
Relevancy 79.98%

I use MS Word 2010 Office suite....I had a word capitalized and decided I wanted it lower case; the word was "caboose." So I did a search for "Caboose," found them, and asked to replace all these with "caboose." I tried this several times, and each time it would say it replaced 9 words (from beginning of document), but nothing actually changed in the document. Any ideas?
 

Relevancy 79.98%

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.
 

https://forums.techguy.org/threads/auto-find-replace-in-a-word-template.790962/
Relevancy 79.98%

Hi guys,

i don't know anything to Macro and looking forward to learn Excel Macro. Just wondering if there's a place i can learn this from scratch?

BTW. I am getting tired doing this more than 100 times/day copying, matching and replacing the data in different workbook. Could anyone of you here teach me how to make a macro to help me out? I'll really appreciate your help.

My data structure as below:

workbook1:
A*******B*******C******
1*S_ID****Date*****Quantity*
2*103*****1/1/09***25******
3*100*****1/20/09**50******
4*105*****2/14/09**43******
5*104*****2/18/09**75******
6*101*****2/22/09**574*****
7*102*****3/1/09***240*****

workbook2:
A*******B******
1*S_ID****Quantity*
2*100*****210******
3*101*****100******
4*102*****80*******
5*103*****15*******
6*104*****500******
7*105*****300******

When i execute the macro/shortcut in workbook1, it will find the matching S_ID in wb1 and wb2, then replace the quantity from wb1 to wb2 correspondingly; and repeat until the end in wb1. As a result, the ending result will be like this:

workbook2:
A*******B*******
1*S_ID****Quantity**
2*100*****50*******
3*101*****574******
4*102*****240******
5*103*****25*******
6*104*****75*******
7*105*****43*******

hopefully can hear from anyone of you guys soon regarding this macro. Thanks in advance.
 

A:Excel 2007 Find & Replace Across Different Workbook

ususim. Welcome to the forum.

Assuming you will have both workbooks open at the same time - this can be solved by using the formula VLOOKUP.

in workbook2, B2

=VLOOKUP(A2,[Book2]Sheet1!$A$2:$C$9,3,FALSE)

copy this down the row.

NB. $A$2:$C$9 is the area in workbook1 covering all you data. HTH
 

https://forums.techguy.org/threads/excel-2007-find-replace-across-different-workbook.877713/
Relevancy 79.98%

Hi,

I'm having some problems with the familiar feature "find/replace".

I have made a query from a web page to a sheet, foreign currencies. As it turns out the currency decimals are marked with dots, not commas and I need commas that I can do some calculations in Excel. Therefore I made a macro (because the query and the change must be automatic) to change the dots in to commas in G to K columns:

Sub ChangeDots()
Range("G:K").Replace What:=".", Replacement:=","
End Sub

As it turns out the find/replace macro doesn't work as it would when using normal shortcut selections (Ctrl+f, >replace....), but instead the macro only removes the dots, without adding the commas, Except if the number starts with a zero. =>(e.g. 1.2345 will transform into 12345 and 0.1234 to 0,1234)

Does anyone have a good explanation/solution for my problem?
 

Relevancy 79.98%

I have 200 page document filled with references of other authors work e.g John (1996), Smith & Will (2001), Nancy et al. 2006 etc. I wanted to check that whether I have provided the detailed reference for all these citations at the end. so I am looking for a way where I can find the all year numbers i.e. 1999, 2003 etc and replaced them with same number but highlighted (let say in yellow).

So how can I search for any four number digit starting with 19 and return the same number with desired formating e.g let say highlighted in yellow

Thanks & Regards
 

A:Find any four number starting with 19 and replace the same with highlighting

https://forums.techguy.org/threads/find-any-four-number-starting-with-19-and-replace-the-same-with-highlighting.1050483/
Relevancy 79.12%

I have a file of hundreds of image files. Many are named like this:

ABC-123.jpg
ABC-124.jpg

...

However, many are INCORRECTLY named like this:

abc-125.jpg
abc-126.jpg


You can see, the 'ABC' part has been lowercased.

Is there any way to BULK find/replace 'abc' with 'ABC' in the file name?

A:Bulk FIND & REPLACE with UPPERCASE of file names...

There are batch renamers, but I'm very unfamiliar with them. I use xnview, which is a freeware image browser, and it has the capability of changing only the case of files.
Say all the files are in a folder. You can right-click the folder and pick browse with xnview. Then click ctrl-A to select all the files in it. Then right-click and pick batch rename.Then make sure all the boxes are unchecked except "case". And in the drop-down menu pick "name uppercase" or "name and extension uppercase". If you need to set all names to uppercase and all extensions to lowercase (and it happens to be a mix of both), do it in two passes.

http://www.techsupportforum.com/forums/f217/bulk-find-and-replace-with-uppercase-of-file-names-390774.html