find & replace

I have the following data (before.png): I would like to have a VBA script which runs through column A looking for a carriage return. Upon finding one, it copies that entire row but only with everything PRIOR to the carriage return - it will make a new row for each iteration. It will then add a...

Hi All, Hopefully you can assist please as my VBA skills are unfortunately lacking in this area. I have a spreadsheet with 2 values in different columns, What i'm trying to do is... Where the value in column S is greater than the value in column F, i want to replace the column F value with...

I have a column of about 4,000 rows of text that has many duplicated values (as it should). I simply want to be able to change the name of the text that is being displayed for masking perposes as the data is sensitive data. I thought i did this once before with an Excel Add in. So every time I...

Just looking for some code that will take a string (stored in a variable named find_value) and double every tilde (~). For example if the string is AAA~BBB I want to change it to AAA~~BBB Thanks in advance (ultimately this will feed into a find and replace operation where if you want to find...

Hi there, I'm trying to create a macro in VBA to search through large amounts of data and change the wording depending on the condition. I want to search column J for "SHIP" and if so, change column A to "TRANSPORT". I've been fiddling with the following but can't get it working. Can anyone...

i have the following code which is able to save within excel a csv addint tilda characters to each appropriate cell and doing a .SaveCopyAs to a new filename. i am trying within the same vba code to open this new file and replace the tilda and comma(since it adds it to the new filen) with just...

Sometimes when I want to find a name in a list using Find and Replace option, but I make a mistake when typing the name, the result won't come up. So is there a way in Excel that suggests recommendations just the way the search engine works? For example: the correct name in Excel is: michael...

Hi, I am hoping someone can help me out with this, I've been searching online but cant figure out how to do it. I need some help with VBA syntax for a macro button to do the following: Find all instances of the word "Main Contractor" across an array of 12 worksheets (MS001.......MS012) &...

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

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

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

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

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

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

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

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

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

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

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

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