replace

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

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