Over 1 million tech questions and answers.

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

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/download.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

Read other 6 answers

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:

and replace it by

now...the name "activeprofile.py" has to be the variable as its not the same for every entry

so its something like this
Find this:

and replace it with:

where * is whatever the filename is...and it should not get replaced

also if its possible can i search for

and replace it with

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

A:[Help] Find and Replace text

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


but how to replace it so it looks something like this


where (\w+) remains unchanged??

someone plz help me on this!

Read other 1 answers

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.


Read other answers


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

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:

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"
Set _tmp=%~1
>>"%_Dest%\%~2" Echo.%_tmp:-}$=-}$$%
Goto :EOF


Read other 2 answers

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?

Read other 8 answers

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?

Read other 11 answers

Text files were 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 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 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
<title>Memory Master Bible Memory Program - NIV - 1 Peter 4:9</title>
<meta name="Microsoft Border" content="tlb, default">

Example: The Way The HTML Code Turns Out After Using Excel To Create The File

<html><head><title>Memory Master Bible Memory Program - NIV - 1 Peter 4:9</title><meta name="Microsoft Border" content="tlb, default"></head>
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.

A:Solved: Need To Replace Text With Paragraph Mark In Text Editor

Read other 6 answers

Hi Guys,

I need help creating a dynamic macro that could save me alot of time in the future.

In a nutshell:

- "Name" value in Column A
- "Yes" or "No" value in Column B
- "Name" value in Column C

I need:

- Every cell in Column 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


------Column A ------------------------------ Column B ------------------------------ Column C -------
-- Jen NO Jen --
-- Jane NO Jane --
-- Sarah NO Sarah --
-- Mike NO James --
-- Mitch NO Fred --
-- Joy NO Lee --


------Column A ------------------------------ Column B ------------------------------ Column C -------
-- Jen Yes Jen --
-- Jane Yes Jane --
-- Sarah Yes Sarah --
-- Mike NO James --
-- Mitch NO Fred --
-- Joy NO Lee --

Thanks for the help,

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"
End Sub

Read other 2 answers

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

Read other 1 answers

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!

Read other answers

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.

Read other 3 answers

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?

A:Solved: Numbers replace some letters in text

Read other 7 answers

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

Read other 2 answers

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.

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

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

Replace with

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

Read other 2 answers

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.


A:Solved: Wanted: Freeware Search & Replace Text Editor

Read other 16 answers


[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

I am trying to write a batch file that replaces a word in a text file with another word given as a batch parameter. I know of the FOR /F command to loop thru the lines. I know also about doing a simple string replacement. But I can't seem to piece it together. Can somebody help me?

A:Batch file to replace words in a text file

Read other 16 answers

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!



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.

Read other 1 answers

On boot, raid screen was saying mirrored drives were both degrading. Rebooted and entered nvidia raid utility(bare bones) to look at drives. Both looked good and could not understand warning message. Saw the clear 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 7. When the flash drive is attached, it sees 7 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?

Read other 4 answers

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!

A:Need Utility For Complex Batch Replace Of Millions Of Files

Read other 16 answers

Is there any software or patch exists for Windows XP Network Connections?

Read other answers

Hi all,

The laptop in question is a Toshiba Satellite A105-S4334. A few weeks ago, it got dropped right on its corner 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 3, 4 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 2 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 $20 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.


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?

Read other 4 answers

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.

Read other 3 answers

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,


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

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.

A:cr lf text file utility

Read other 11 answers

In IE version:11, When user selects a text and tries to drag it. The selected text appears dark on left hand side and shown as faint text on right hand side.
see below screenshot for your reference: 

Read other answers

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 ?


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

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

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.

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:

Read other 1 answers

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

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

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

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



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

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. 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 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 mainframe log.

What I am looking for is how to set the printer up on Windows server 2008 64 bit version. I have Blue Zone and can consider other software. The older version of this used Reflections as a printer emulator.

Read other answers

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


Read other answers

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.

A:Multiple Find Replace

Read other 8 answers

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:

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

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:
But different replacement numbers

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


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

Read other 3 answers

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.
Slight learn curve - read help files etc.

Read other 28 answers

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?

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

In what program?

Read other 1 answers

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

A:Solved: find and replace

Read other 12 answers

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!

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.

Read other 3 answers

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

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.

Read other 2 answers

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<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 help because it replace 2 times because sometimes the replacements have the exact word that I’m also looking for.

Selection.Replace What:="TIPOLEIJ", Replacement:="POL-222869;LIN33359;MC5875;DS23659", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
Selection.Replace What:="MC", Replacement:="MNDJ", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _

When it search for the word “TIPOLEIJ” it replace with “POL-222869;LIN33359;MC5875;DS23659" but when it search for MC it change the “TIPOLEIJ” replacement to “POL-222869;LIN33359;MNDJ875;DS23659” Im wondering if there is something that after it replace the value “lock” the cell so its not replace again.
Hope someone can help.Thanks

A:Find & Replace Macro Help

Can you post a sample workbook?


Read other 3 answers

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

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 field for "Run as" the string [oldcomputername]\Administrator". 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 computer name to the new one.

Is that even advisable in the first place and, if so, what utility would I want to use?


A:Find-and-Replace in XP Registry

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

HTML Code:

Read other 1 answers

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:

And in C1, enter:

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



Read other 3 answers