find and replace

Hi, There! I am looking for a way to use Power Query to replace text in two diferent columns based on a column. This is a report coming from HR listing daily information about punch cards. It contains the names of personnel and their time stamps and overtime code. I have this column reason...

XREPLACE is a powerful find/replace solution allowing for replacing by any or all of four categories, i.e. value and/or count and/or type and/or length; single or multiple elements within each category; and control over priorities of all categories I developed XREPLACE in response to feedback I...

I am making a bracket for basketball teams by region. I select the winner of the game based on a list referencing the named ranges you see pasted below. I pull data from multiple web queries into each regional bracket and have many formulas. Because of this, its quicker to copy the sheet and...

Hi there, I want to create a macro where I can find and replace the wording of my data in one column depending on the condition of another. I would like to search column A for "Scotland" and "Southern" then if column J is "SHIPPER" change column A to "Scotland Transport" or "Southern...

Hi, hope you are doing well. New here and love to work with excels macros to do my job easier. I'm looking for an example on how to update a cell in sheet2, base in the info of sheet 1 Sheet1 have column C with the unique record number, I need to fine that record number in Sheet2 (column C)...

I have a repetitive task daily that could go away with the help of VBA. I have a sheet that lists a large group of retail stores. In column "U" of the sheet "Future_Launch_Locations" it has the state that the store is in. In column "N" I need to fill out an HVAC Provider. A second sheet...

My data has many number wherein some values are between 0 and -1. I labeled all of them with conditional formatting. However, it took quite a long time to replace all of them by 0. Is there any solution that help me to finish this more efficiently? Thank you very much.

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="https://example.com/abigail.html"><img src="https://example.com/abigail.jpg"> Abigail</a>2Sophia<a...

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

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

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

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

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

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

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

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

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

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: https://www.twitrss.me/twitter_user_to_rss/?user=barkingcollege However recently there has been an issue with a security certificate on...

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

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