replace

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

Hi I have an excel file report that I need to check daily. In that file I have some columns with numbers but some cells do not show any number. They should show zero, but when doing ISBLANK they should as FALSE (not blank then) I want to create a Macro that: -checks within the columns E8 and...

Hello, I've got a weird problem where I'm struggling to detect the last occurence of the character "-" and replace it with "x". Does anybody have a way to take a string and replace only the last occurence of that character? (I've gotten a replace function to work, but it replaces ALL...

How can I create a condition relating to the cell that the formula is written in without getting a circular reference? Let's say I have a formula in A1 and it is said to return the letter in B2. How can I make it such that "If the letter in A1 is "Z", replace it with "X" instead" in the A1 cell...

I created several formulas with slightly different cell references and realized I needed to add an additional conditional at the beginning of the formula. I wanted to do a find a nd replace, but adding the additional conditional at the beginning requires adding a close parentheses at the end...

I'm trying to use this formula: REPLACE("S";1;1;"O") To remove the first instance of S only. An example of what the column would look like: <tbody> T O O P P T S S P O T O O </tbody> Sadly, It is necessary that I drag the formula I have down thus resulting in all the...

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

Hi, i need some help. I try to google but see hard for me :( In myweeksht; At Column D 1. Find WPxx And Replace with 'Poster' 2. Find number (the number can be single or double digital) And replace with 'Route' <tbody> Col D Col D (Result) WP1 find WP @ Col D & replace with 'Poster Poster...

This is my first post, so apologies if I miss anything out! I have a selection of data in a Worksheet and I am currently using a find and replace array to correct some data before it get put into a Pivot Table. The problem I am stumped with is that the source cell (Column D) can contain a...

Hi there, So I've been given a task to find and replace items in a spreadsheet with a range. Now I've had 0 experience in VBA before this, so I'm a bit confused. And could use some help. I will put it as simply as I can, because my brain gets confused when I go into the details of the task...

Hi, I'm looking for a VBA routine to replace all values in COL A that are greater than 15 and less than 999, with the number 16. Thanks.

Hello I want to use back references and regex with Search and Replace, is it possible? Thanks!

I would like to find specific digits in a cell and replace it with a symbol or some text like "duplicate", not the whole cell only the duplicate characters in the cell. I have one column with more then 2500 rows which contains contact numbers. Every cell contains more then one number. then i...

As the title suggests, I would like to know if it is possible to use a variable in a formula. The specific application may also have other solutions. I am trying to bring in data from an external workbook. I am currently using an index/match formula to select the data to import. example...

I have a rectangle with an image fill on sheet 1. On sheet 2 I have images that aren't a shape, they were just drag and dropped into Excel, but they are located within the cell borders I'm trying to figure out the code to take the image from a specific cell on sheet 2 and replace the shape...

Hi. I want to ask one problem, I have one column which is column "M". If there are any blank cell in column "M", then it will replace with "MPTV". So, it will loop start from row 2 until lastrow. here is coding vba that I've try but cannot. Sub REPLACEBLANK() 'replace Blank to MPTV...

Hi all, This has been quite a wonderful forum and great place to learn. I have the below problem which I require some advice. 1. I am trying to consolidate the sales of a few items from 3 different sources (3 different worksheets) 2. These 3 different worksheets name all these items...

Hello, I'm having trouble with a "find & replace" formula in VBA. Namely, I have 2 columns, Column "BH" where it will find current value and Column "BI" where I noted what the found value should be replaced to. However, both are 4 digit numbers and start with a 0. So, I'd like to replace "0001"...

Should be an easy solution but i can't seem to figure it out. Let's say you're looking for a specific word in a data set using the find and replace function and hit 'find all' - it displays all the results for the word you find. All i want to do is copy the 'Cell' reference output and paste...

Is there a way to clear all cells which have formulas but return 0 value? Im trying to reduce the file size of my spreadsheet. Ive seen some suggestions to use "Find and Replace" and replace all cells from "0" to "" but Excel doesn't allow find and replace on values, only formulas.