replace

Hello! I am struggling with a function to link to a macro that requires me to copy a set of values from one sheet to another, while these values depending on a certain month that I link, and then asking the user a Yes or No question on if they want to replace these stored values for that month...

I have a list of phone #'s in the format 519-555-5551 410-555-5222 I would like to remove the dash so the output looks like 5195555551 4105555222 I've tried find and replace but it does not work. Any thoughts? TIA

Hi, Hope I can get some help with adding code to loop through the dates in column A of Sheet1 & compare them to the dates in Column A, Sheet2. If the date on Sheet2 is greater than Sheet1 run the MatchColumns macro. Sheet1 accumulates jobs with recommendations through out the year. Sheet2...

Hi I know how and when to use substitute() and replace() function. But my question, I found that Replace tool is doing the same. Is there any case that Replace tool is not going to help then I will have to use substitute() or replace() functions. Thank you very much.

I have pieced together different bits of code over the past few years to format a P&L report being generated from an accounting system. The vba is starting to run slowly and I'm trying to clean it up to make it run a faster. The report being formatted has 100 tabs and the code formats each tab...

i am in the need for a regex for my vba project. i need to replace the - dash that is in-between numbers only, example 1-3-1. The problem is i have negative numbers with dashes which i need to keep, but the patterm is consistent, 1-3-1, should be 1,3,1 so replace dash between digits with a...

My workbook contains many sheets and before closing the workbook I would like to replace the same cell on all worksheets with the same text. For example, certain cells replace all that start with "rateid_???". I have tried the following code but receive an error on the IF ws.Range…… row. Could...

I have an excel document that I get every month. I would usually type the formula =IF(Q3="I","Colonial FS Insurance","Colonial 1st State") into cell AB3 then double click the corner to drag down to the last row. The number of rows changes every month and can be anything from 30 to over 2000...

Hi I have a macro which runs some SQL code to update a table on a server. The code and SQL has run fine in the past, but I've hit a road block now, seemingly because SUBSTITUTE doesn't seem to like swapping in a really long string (~35k chars) for a short string into a STRING variable. If...

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

I have an Excel question that I am afraid is out of my range of expertise. I have a list of items with inventory values. What I need is either a formula or script that will say if the value is zero, then grab the value from the next line for the same item number if it is not zero, and continue...

Hello! I have 2 of those curly bracketed formulas that I'm using to basically VLOOKUP repeat values that have different data in the cells next to them, but are slowing my file down so much macros literally take 5 times as long to run. Can you awesome guys help me replace them with something...

I need some help again :D I need to find from Column A2 below from Data (sheet) and replace from Column A2 below keyword (Sheet) replace format as what found in Keyword sheet A1 is header

I have an email template stored on the desktop, labeled Email.msg. The Email template is in HTML format. I want to take a cell containing the recipients name from a cell in Excel and adding the name to the Email template. I have put a placeholder in the places where the recipients name should...

Afternoon All, iv searched quite a bit but cant find a work around for the formula i am trying to create and am hoping some one could point me in the right direction. i am currently using the the following formula: =SUMIFS(Sheet1!D:D,Sheet1!G:G,"billy",Sheet1!E:E,"Smart") this works great...

I want to find "" in Column F and replace with "" :)

Hello, I seem unable to find a way to first copy n paste say Column B:B to sheet2 say A:A (I do this fine lol) Then I want to run a find and replace on Sheet1 col b:b without the find & replace doing the same thing to sheet2. As I want to then copy sheet2 a:a to sheet1 a:a to create my cross...

I am using a sub I got from the internet that randomly highlights cells. what I need is to have the counter reference a cell instead of being set in the code (see below). I want to be able to put a value in cell H1 and that replace the 150 in the formula. This would make it easier as my sheets...

Hi Can someone advise whether this is a way to replace the line marker with number label, like the picture below? https://ibb.co/CVc5HPf

Hi Is there a script that would look at say, column F, and if the number of character length is 3 or less, replace that number with 2100? Thanks Jay