find and replace

Version: 2007 Need to find a replace the following: Find '=+' Replace =+' It is not finding the formula (written as text). I am trying to replace the single quote with nothing so it becomes a formula again. I thought the tilda placed before it would help find it but that didnt' work. Of...

I have a data sheet where the text is separated with the empty rectangle character and would like to replace it with semicolon to complete a text to columns. First, I used the ctrl+h function, but was not able to copy the character in the Find What field. I also tried pasting the character into...

I have a lot of text (html) in a cell and several find and replace events in a macro. All but 3 of these (identical) events work. So to test I did a find from the ribbon... it didn't work. To make sure, I went into the cell and copied a bit of the text then pasted it into the find box... and...

I have 1000 excel records where one column contains a chat transcript. The chat transcript contains multiple questions and responses in text with date stamps with in a single cell. I want to be able to strip all numbers in the text contact except those that are in a date. Example (in a single...

I need to write Macro for this. Column 1 has the original values and Column 2 has the values that should be replaced in Column 1. Column1 Column2 ABC | QWE qqq | ASH ERTR | PRR qqq | DIA Find for "qqq" in each row and replace with corresponding column 2 value. After replacement it should...

I have a column which contains a certain formula. In some of the cells in the same column there is the error message #N/A. I need to replace such cells with blank cells. But when i am using the find and replace feature, it looks into the formula in the cells and not the results and thus is...

Hello there, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> This is my second time to ask a question, my first experience was absolutely wonderful, the reply back was almost instant.<o:p></o:p> Ok, I am reconciling a bank and the check number where there...

Hello All, I use Ctrl+F -- Find and Replace command in Excel. I want to find a specific word in Excel, all sheet (in Workbook I mean). I press Option>> and change Within: sheet to workbook and found like a thousand of results. I want those result show in a new sheet because I want to create...

Hi all, Looked hi and low, but cant find an answer anywhere. I have 16000 entries containing "?? > ?? >" (?? being unknown numbers) I need to remove the second ">" whilst keeping the one between the two number groups, therefore becoming "?? > ??" Below is an example: <table...

Hi. I'm wondering if anyone can provide a quick way to do a find & replace one email address that's in a few hundred excel files that are all within a single folder. Thanks very much for your solution and your time.

Hello, I'm having a problem with Find & Replace- I'm pretty familiar with it and have used it a bunch but for some reason Excel is returning no matches when I search for the following: USD (S&P 500) S&P 500 In dex USD The above is entered in 1 cell WITH returns...not my formatting it is...

Hi, I have a series of cells. Some of them end with the comma, and some do not. Some have really weird stuff in them (like manual line breaks). Now I would like to go through each of the cells, and delete the ending comma when it occurs. Can I do this using the Find and Replace feature? Note...

I have a large file - 50,000 records. I am trying to match up data. Its an export from a CRM. One file is contacts, and other is Accounts. Each has a RECORD ID field, which I am trying to key on. I merged the two, but where i am running into trouble is trying to do a find and replace. If...

Hi, I'm having this problem whereby a few cells in my work contain empty texts. An empty text is represented textually in VBA with a pair of double quotation marks with nothing inside (I think). This means that the cells don't display anything visible, but are not blank/empty. So what happens...

hello everyone, new user to the forums. tried looking this up but couldn't quite find it. i'm using a mac and running excel 2008 and trying to take the underscore out and replace it with a space so from: ibm_us to: ibm us i've looked and some people said you could just leave the replace...

Hi Guys, I am trying to execute a simple find and replace statement... It needs to loops through all the cells in column H of the sheet called HIST. If it finds the value #N/A then it needs to replace it with the value 0.00 I have tried... Sub findrep() Dim target, cell As Range...

Hi, let's say I have data in columns A-B, and a target list in C: A B C dog 21 dog cat 43 mouse mouse 21 lion puppy 45 lion 23 What I need is a way to...

Hi i need some code that pops up a box, allowing you to input a name which searches all sheets of a workbook and then deletes the entire column which it is found in.. I need it to prompt whether to delete it or not before it does!! Please help Thanks

I have created a template that has a macro that pulls data from a spread sheet (Monday) and pastes in another spread sheet (Prodweek). When I adjust the template to be updated for a new week. I just do the find and replace with the name (Prodweek) and the date span of the week. I am by no means...

Is there a way to stop Find and Replace? I selected over 10,000 cells containing formulas and started a Find and Replace. However Excel asks me to locate the desination spreadsheet for each and every cell. How can I get out of this cycle?