find & replace

  1. Z

    Find and paste value if found VBA help!

    Hi All, Was wondering if anyone could help me with this. Basically I would have two work books with changing names, but would consistently have the same format. The unnique idetification number in both is in column A, and the values are in column E. I would want to replace the values in...
  2. B

    VBA code to loop throug a column and find/replace

    Hello People, Can someone help me with below requirement. I have a cell address stored under address1. now I want a code which loops through entire column of "address1" and if a number zero is found then it has to check the value of its immediate left cell and 1. if it is NA then zero should...
  3. A

    VBA Replace text in column, if column header is a specific text

    I have a report which plots venue availability against dates (see layout below) The information comes through as Fullday / Morning / Afternoon, and if used will say Booked. None of the venues are used on Sundays, except to set up. However, this data still comes through as a full day...
  4. M

    Find Replace #N/A with Formula

    Good afternoon, In a particular column I'm trying to find all the "N/A"s and replace it with a formula. Is there a way to do this that won't get me a mistmatch error? The error is occurring starting at "Selection.Replace" and ending at "ReplaceFormat:=False". Sub Step_3()...
  5. M

    Macro/VBA to find and replace over a range of cells in multiple identical files

    Hello, wondering if someone can help me write a macro to find and replace all instances of "$C$214" with "$C$216". A few more details... - I need to replace these values in the range E50:WG51 on worksheet "Monthly CF" - The "Monthly CF" file is not the only worksheet in the file - There are...
  6. A

    Replace multiple underscores with fixed number of underscore

    Hello everyone, I have a long list which contains text with underscores where some are 3-4 at one place within one cell and at some places there are more than 5: <tbody> I ___ like to make a ________ for 4, please. </tbody> I want to find and replace them all with 5 underscores like this...
  7. T

    Excel VBA Range Scope for Find/Replace

    Greetings, I am interested in doing a Find/Replace on a specific range. Controlling the scope to Worksheet vs Workbook seems to be my issue. Doing a regular replace produces inconsistent results: Selection.Replace _ what:="abc", Replacement:="xxx", _ LookAt:=xlPart...
  8. T

    Looking for a faster way to find and replace

    Hello there, I have a worksheet with about 120,000 lines with probably 50 columns and I run the following code to change all the #'s to blank cells. I was wondering if there is a faster way to do this, because this takes a long time to complete. Sub NtoBlank() Cells.Replace...
  9. M

    Spaces in tab names

    Hi, I'm trying to extract some data from an old workbook which is locked (and the password is unknown and I cannot crack it). I have managed to type in the location of data in the old workbook into a new workbook to extract it (=[OldSheetName.xls]OldSheetName!A1 and fill down), which works...
  10. J

    Remove Duplicate Text STrings from Single Cell

    I have a list of terms in one sheet (Find List) I have a column of text data "Replace Data" in another sheet that I need to search for exact full words/phrases in the Find List and if multiple instances exist in the text data of Replace Data, I need to eliminate all instances of that exact/full...
  11. X

    Replacing Wildcard Text in Find/Replace

    Is there away to “move” the info that’s captured with the * wildcard character when you’re using Find & Replace? For example: I’m looking at a sheet with the following in Column A 1 Public Records of Baltimore County, State of Maryland 2 Public Records of Cuyahoga County, State of...
  12. J

    Find Duplicate Instances in one cell from List of Target Phrases

    I have a list of terms in one sheet (Find List) I have a column of text data "Replace Data" in another sheet that I need to search for exact full words/phrases in the Find List and if multiple instances exist in the text data of Replace Data, I need to eliminate all instances of that exact/full...
  13. D

    Applying a Find and Replace macro to only cells highlighted in Red?

    Hi Folks, I am working on an address book. I have some VBA code to look at any 'selected range' of cells within the address book; it then finds words within text strings that match words stored in another table (the findList)---stored in column A of table 1. If it finds words within the text...
  14. D

    Find and replace macro targeting words within words - can it target only whole words within a string?

    Hi Folks, I am attempting to use VBA to modify address data because the first two address columns have character limits and my data tends to exceed the limits. I wish to modify text strings within cells i.e., to find and replace words within text strings with abbreviations. For the below code...
  15. P

    Multiple Search and Find Problem

    Hi there, I'm struggling with a multiple search and find. I have 26 separate worksheets that are all in different languages. I am manually putting them into one worksheet (not sure if that's the fastest but I'm a newbie to all this). And then I need to get them all to be in English. So... for...
  16. B

    Replace text after nth occurance of character?

    I have a list of IP addresses: 10.9.8.14 10.9.8.24 10.9.8.17 10.9.8.56 10.115.4.3 10.115.4.16 10.115.4.88 10.24.2.132 10.24.2.55 I am looking for a formula to take this column and generate the following in the next column: 10.9.8.0 10.9.8.0 10.9.8.0 10.9.8.0 10.115.4.0 10.115.4.0 10.115.4.0...
  17. N

    Find value and then reference cell 2 above

    Good afternoon, Sorry if this is repeated by I'm not even sure how to work this. I have a call that has the value "Total Cash". I am using this to find the cell. I can also use find and replace. Cells.Find(What:="TOTAL CASH", After:=ActiveCell, LookIn:=xlFormulas, _...
  18. H

    Format with numbers problem!

    Hello, guys! I'm trying to covert a column full of numbers like 1234,56 or 987.654 to this format 1234.56, max 2 decimals and "." instead of ",". But when I try to find the "," the method completely ignores it... I tried to change the format from General to Numbers, Text etc., but no success...
  19. The_Rock

    Find & Replace Chart Name for a Single Chart

    Hi Folks I've found online a way to find and replace words in a title for all charts on a sheet but I want to be able to specify specific charts. In the example below, I only want to update Chart 11. As I turned off the For/Next statement, I set ch as ChartObject It crashes on the first line of...
  20. Y

    Using Find & Replace to add parameter to VLOOKUP formula

    Hi guys, I have a spreadsheet with hundreds of VLOOKUP formulas that were inputted by a previous user. The formulas are correct except that they were all created with the VLOOKUP default settings that leave out the optional final parameter for Range Control and now need to be modified to...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

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

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

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

Disable uBlock

Follow these easy steps to disable uBlock

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