replace

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

Hello Everyone! I desperately need your help! I need a code to do the following: sheet "template": column a must always have a numeric value. column b must always have alphabetic value. sheet "colors": column A and B will have the values as needed. For example 100 is Black, 200 is Blue etc. Any...

For each row where there is text in column E, copy the entire row and insert it below the original row. Then remove the text in column E from the row that was copied.

Hello, I have a report fire every morning (1 workbook with 1 sheet) showing what active items need to be worked on (my team tasks are no color fill rows and all others team tasks are grey fill rows). Columns A and lets say J are blank for me to write status notes/dates in. Once I push it out...

Hi everyone, Is there an excel VBA code that allow you to replace part of a formula after cells selection ? For example, after selecting multiple cells, select the code to replace SUBTOTAL(9, with SUM( Some formulas examples: =SUBTOTAL(9,EA10:EA12) change to =SUM(EA10:EA12)...

Hello, I have values that are pulling in from my data set as "Name-Email". I would like to only keep the Name. Is there a formula I can use to get rid of the - Email part?

I have a range (let's call it the A column) that has dates in this format: dd.mm.yyyy so I want to change the format to short dates d/m/yyyy Instead when I use range.replace, it takes the values as if it is in the mm/dd/yyyy format. How do I replace it. Sub format_dates()...

I have two different delimiters ("[]" and "()") that I'm trying to replace with a space. They start at the beginning of the cell. Below includes an example with the solution ("desired output" column) I'm trying to get to with an excel formula: Data Desired Output (looking for a formula to...

The following is an example of text that appears in a header in the Power Query editor: 11/16/2023 Points Diff. The date is different in each cell. I would like to replace the cell value with just the date (e.g., drop the "Points Diff."). When I use Transform/Replace in the editor for...

Do you know how to replace text-with-wildcard in a string. Below code doesn't seem to work. simplify_text = "W(left_1_right)" simplify_text = Replace(simplify_text, "W(*1*)", "W(1)")

Hi all, I hope the title makes somewhat sense, but allow me to elaborate. I have a setup like this: I want my numbers in column D to replace whatever value is in column B However, if I mark all of column D and move it other to column B it will say the following: If I say yes to this, I...

Hi everyone. I need one VBA Macro code and just cant go trough it...I ll appreciate any help. So, I need the following.... If cells in column B start with "1" (i have numbers like 3003, 3200, 11000,10022 etc..) then empty/erase cells of the same row from column "O" to column "Q". Thanks in...

Hello, I have two strings of letters (columns String A and String B) and I want to transform them into strings like the ones in Solution 1 and Solution 2 correspondingly. String A String B Solution A Solution B 7-6-1-3-4-2-2 DDDDDTT 7-6-1-3-4-2 DDDDDT 3-3-0-2-0-0 DDTDTT...

Hi Power Query gurus out there! I'm going to do my best to explain some help that I need it replacing values, conditionally based on another column's values, while dynamically referencing field names. Here's some sample data: Date Greeting Appreciate Patience (if hold was used) Resolution...

Hi there: I've been looking at some other posts on replacing text entered with values from two arrays. Works when the values exist in the array; however, if the user enters a different value, then I'd like replace it with "". Please see what I have so far below, and let me know if you have any...

Hi all, I currently have a very large data sheet that looks like this: In this example, I've just put in a format of: Date,Name,Gender Please note that some of the cells however might only have Date,Gender or Name,Gender or Date,Gender etc. My ideal format would be: Date,Name,Gender...

Hi! I'm very new with VBA so I mostly use the 'record macro' function, to then learn from the code and combine pieces I want for a macro. I am European so we use a comma for decimals and not dots. Many, but not all files I work with have dots though, and my European version of Excel cannot...

Hi there, I have a long list of Image urls in a column all which have image dimensions, for example https://example.com/wp-content/uploads/2022/07/sample-image-300x212.jpg . I need to remove everything that dimensions 300x212, these dimensions vary. I thought I can replace this -*x, with x and...

Hi This has flummoxed me. I have attached two images showing how the address details are displayed in the cells, and how they are displayed in the drop down preview section. As you can see there is the odd square symbol representing a line break in the main cell section and the line break in...

Hi there. I did one macro to find a value, then change a cell's value with an offset. Just a string. It is working. Now I just wanted to use the same macro, but I dont want to replace the content from the offset matching cells with a string but with a formula. And I have tried for hours to find...