find and replace

  1. C

    VBA find and replace entire cell contents

    Hello, I am running Excel 2021 and I have a two sheets, here's Sheet1, it contains values of find (col A) and replace (col B), there might be 1k of rows in there: AB1Abigail<a href=""><img src=""> Abigail</a>2Sophia<a...
  2. C

    Find and replace from access to word

    Hi all just recently migrated to access still learning hoping somebody could point me in the right direction. So I have a table containing property serial number as well as location information for inventory purposes. What im Trying to do is figure out if theres a way to loop thru each...
  3. P

    Anonymisation using excel macro / find and replace

    I recently read the following article on using find and replace to correct typos in city names based on a list of corrections Find and Replace based on a List I was wondering if the same principals couple be applied for a large scale anonymisation of a dataset replacing peoples names such as...
  4. J

    Find and replace for multiple terms

    Hello all, I need to perform a find and replace on multiple values that I'm sure can be coded in excel. I have a list of address that have certain words that need to be replaced with a '~' symbol and some terms replaced with their abbreviation. For instance: Addr addr_2 123...
  5. T

    VBA Bulk Find and Replace or Similar

    Hi there, I’m looking to do a large amount of find and replace on some data in two columns. (B:C) I’ve been trying to do this in an efficient way, as I can tell the macro recorder doesn’t make this easy to read and becomes a bit convoluted if I do a basic find and replace on a selection. How...
  6. E

    Delete words in a column based off a list in another column

    How do you delete specific words in one column that's based off a list of words in another column? For example, let's say in column A I have: A1: Carrots are orange. A2: Green peas go great with garlic butter. A3: Watermelons are red on the inside and green on the outside. And in column C are...
  7. M

    Find and replace in all sheets, and replace in exact format and properties

    Hi, I got this code from another post. The solution is amazing and really helps me. I would like to know if there is a way so I can 'Find' and 'Replace the exact value' The values I'm replacing with are hyperlinks. So I would like to replace the new values with those hyperlinks and keep them...
  8. H

    Find and Replace Loop Using Spreadsheet

    Hi all, Sorry for the beginner VBA question - I've been stuck for a while and haven't been able to adapt any answers from this forum to quite get the results I would like. I have a range (B46:C54) on multiple sheets that contains values that need to be used in a find and replace. B46:B54...
  9. D

    Outlook VBA - renaming outlook folders using find/replace code that references excel workbook/sheet: it converted all folder text to lowercase

    Hi Folks, Basic issue: I have a requirement to rename many outlook folders/sub-folders and I thought I'd found the perfect outlook VBA code; however, I have two issues with it 1) it's changing the case of my outlook folders to lowercase 2) It's doing part matches. Detail The code below...
  10. D

    Find and Replace Within Validation Limitations

    I have a worksheet with cells that have validation limitations allowing a list as a source. These cells need to be editable by all users. When changing a validation cell manually, the input is limited to the validation rule assigned. Due to the vast number of cells that may need to be changed at...
  11. F

    Batch replacing External Connection Stream

    Hi, I currently have a spreadsheet that includes lots of pages imported from external data (an external website). The links that I used were similar to: However recently there has been an issue with a security certificate on...
  12. R

    A complicated one... is this even possible?

    Hey forum folks, I have a problem. I need to replace: HERE in B2 with the data in C2 HERE 2 in B3 with the data in C3 HERE 3 in B4 with the data in C4 HERE 4 in B5 with the data in C5 HERE 5 in B6 with the data in C6 And I need to do the same for every cell in column B. Is this possible...
  13. Jambi46n2

    VBA Inputbox Find and Replace Help

    I am trying to conduct an automated Find and Replace with VBA Inputbox to simply replace this: 07 July 2019\SpeeDee Royalty Calculation\07.27\Sales Reports\[07.27.2019 Nexgen SpeeDee Report.xlsx]rptCustomMonthlySalesOverview'!$A$4:$I$102,5,FALSE) To This: 08 August 2019\SpeeDee Royalty...
  14. C

    VBA Find and Replace other column and IF statement

    Hi, I have a dataset where I want the following and I am stuck. I have a datasheet, where I have clientnumbers in column E and in column Q the type of business of the client (i.e. new business, lost business or excisting business). Sometimes Column Q is not correct, so I have a correction...
  15. M

    Find and Replace

    Hello, I am trying to find and replace 2 place decimals numbers in a column with 3 place decimals using vba. The problem is that some of the numbers are over an hour (1.16 should be 1.167) in time. I tired using wildcards, but it seems to put the wildcard character in with the number. Any help...
  16. J

    Find and Replace with formatting between two Characters

    Hi all, I'm looking to find and replace with formatting between two characters. For Example: I want to find all instances of: |Some Text| and replace it with Some Text. Basically, it would remove the containing characters "I" and bold the text within these characters. Any help would be...
  17. W

    Find and replace as well as find and delete

    Hi all, I saw a post by Trebor76 that has helped me to come a few steps forward, but i still have alot to solve and i need the help of some skilled VBA Excel users. I am quite at the basic level in Excel VBA and i will really be thankful if someone can take sometime to help me out I have data...
  18. Z

    Changing "value" into "any value in a specific cell" in VBA

    Hello everyone! I want to build a macro or use a formula which allows me to search the value of (let's say)"search" cell K10 in a table spreadsheet. Jump to it, replace the background with color green, and jump to the cell next to it to the right (The value of K10 is in E171, fills the...
  19. D

    Remove Parenthesis and their Contents

    I am just starting to dabble in Access and I need to remove any parenthesis and their contents from my field "CustomerName". In Excel I would do a Find and Replace of "(*)", but that does not seem to work here. Thanks as always!
  20. A

    Find cells that start with a specific text and replace with

    Hi all, I am pretty sure I've been able to use the find and replace function for this before; I have a complete brain freeze. I have a lot of entries on excel; they are urls. Some of them have the root domain included and some don't. for example: /product435...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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