find & replace

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

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

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

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

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

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

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

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

Hello - this site has always been a great source of help once again i am looking for VB code that will select from cell H4 out to the last column/last cell then with that selection perform two functions find null values and replace with NR copy the conditional formatting of H4 and paint brush to...

I am trying to create a Excel VBA Macro to find bold text within cells with non bold text and add html bold tags around the original bold text and leave the non bold text alone. Example: Find: "This bold word" and Replace with: "This <code style="margin: 0px; padding: 1px 5px...

I am trying to iterate through and change serial numbers of a worksheet based on the updated table of old serial numbers with their corresponding new serial numbers. Here is my code. Sub what_am_I_doing() Dim i As Integer Dim sht As Worksheet Set sht = Worksheets("RtgCmt")...

Hi all, I'm looking to execute a find & replace on a dataset whereby anything containing the value 'xxx' is replaced with the value 'xxx'. For example, in a set of: yyyxxxyyy hhhxxxhhh xxxhhhhhh wwwaaaxxx xhhaxxghh After the find & replace, I would like the cells to read: xxx xxx xxx xxx...

This might be super easy but here goes. I need to see if a "Product Name register mark" lives in column C. If it does, then the register mark for that Product Name needs to be eliminated in column AB. Also, I need to see if a "Product Name" has a register mark in the first instance, then it...

Hey guys, So this one is really getting in the weeds. I'm using the following code to convert a series of names in a cell delimited by commas to codes the names represent, with spaces and commas delimiting, still as text in a single cell. 3 Part Question: As is, after I run the script I'm...

Hi all, Quite new to VBA but would be very grateful if someone could help me with the below. I can't figure out the code I need in order to go into a text file, remove lines 10, 11,12, 13 & 14 in the text file. I've seen threads with the find and replace in a text file but cant use these as...

Hello everyone i have assigned a work in excel like find the word for example in column A i have list of words and in column B i have list of words so now i want to create a program like if i type particular word from Column A or Column B the cursor should go to that particular row where that...

Hi, I have tried recording a macro to copy and paste values then find and replace values of 00:00:00 with "" throughout the workbook but it doesn't work when I run it. Any advice would be much appreciated. Thanks.

I have had to merge two copies of a workbook and to do so requires me to find all references to cells that may have now a different location. I am using the find function to locate all the cells and trying to use the replace all function to speed things up. The only issue I am finding is when...

Hello everyone, My goal is to find all YELLOW highlighted cells that are currently empty, and replace it with a vlookup formula like this: =Vlookup(A1,A:Z,2,False) The issue is when you use the Find and Replace function, the lookup value of A1 is an absolute value. I need the lookup value to...

Hello I need some help with a few pivots I am creating using vba. I'm facing the following issues with my pivots: 1) Not being able to sort in descending order basis the values in the grand total. I have tried using the recorded code as well as written code on my own, but it does not seem to...