find and replace

Hi, I have a dataset where I want the following and I am stuck. I have a datasheet, where I have clientnumbers in column E and in column Q the type of business of the client (i.e. new business, lost business or excisting business). Sometimes Column Q is not correct, so I have a correction...

Hello, I am trying to find and replace 2 place decimals numbers in a column with 3 place decimals using vba. The problem is that some of the numbers are over an hour (1.16 should be 1.167) in time. I tired using wildcards, but it seems to put the wildcard character in with the number. Any help...

Hi all, I'm looking to find and replace with formatting between two characters. For Example: I want to find all instances of: |Some Text| and replace it with Some Text. Basically, it would remove the containing characters "I" and bold the text within these characters. Any help would be...

Hi all, I saw a post by Trebor76 that has helped me to come a few steps forward, but i still have alot to solve and i need the help of some skilled VBA Excel users. I am quite at the basic level in Excel VBA and i will really be thankful if someone can take sometime to help me out I have data...

Hello everyone! I want to build a macro or use a formula which allows me to search the value of (let's say)"search" cell K10 in a table spreadsheet. Jump to it, replace the background with color green, and jump to the cell next to it to the right (The value of K10 is in E171, fills the...

I am just starting to dabble in Access and I need to remove any parenthesis and their contents from my field "CustomerName". In Excel I would do a Find and Replace of "(*)", but that does not seem to work here. Thanks as always!

Hi all, I am pretty sure I've been able to use the find and replace function for this before; I have a complete brain freeze. I have a lot of entries on excel; they are urls. Some of them have the root domain included and some don't. for example: www.example.com/product123 /product435...

I've been using everyone's favorite multi find and replace code for the past 2 months and it's been wonderful, but it is still not exact enough. I put it into an addin and tied that to a button so now I just click it select the text I want it to replace and then select a table I have in another...

Hello, I have searched the forum for any macro resembling the one I am trying to create but no luck... I am not an expert in VBA but I know other programming languages so the algorithm I am trying to create is clear but I lack the knowledge in Excel macro syntax to make it work... Basically...

Basically is it possible to find and replace vlookup formulas in a sheet and replace with their resulting values without impacting any of the other formulas in the sheet? Like a find and replace if formula contains vlookup with that cells value? Thanks, Joe

Hello all, I am not new to Excel, but I have never messed with formulas or documents with large amounts of information. However, I am now faced with doing weekly and/or monthly updates on a master spreadsheet/workbook that has names, case numbers, completion dates, and other personal data. I...

As a newbie I couldn't done it. Sorry for this low level question, I need C1. Thank you. <tbody> A1 B1 C1 apple A lot of apples A lot of .....s interest I've interested in giving examples I've ........ed in giving examples </tbody>

1. This code below works for another purpose, but I can't figure out what to change for another use when Column B (sheet 2) has manufacturer numbers that repeat themselves. I have attached a picture below to show you (sheet 2) and how the numbers repeat. 2. What I want it to do: For example...

Hello, the code below seems to break at the occurrence of the special character "_" on the headings with "TXN"?? Or that have "_" and "two_words" vs. a "word_number". Any thoughts why it cant handle that / how I can fix it? ORIGINAL DATA SET <tbody> DMC_1 NSN_1 Date Quantity Unit Price...

I have a need for vba Code that will list out all cells that match specified string in a workbook. Like when I use the "Find and Replace" tool in Excel. However, I need the code so that I can save out the report. Can someone please help with some code?:confused:

Greetings, I'm attempting to create a macro that will search a worksheet for potential issues with HTML code. Our systems recognize &# 174; and &# 153; (sans spaces) as ® and ™ respectively, but if we attempt to use &174; or #153; it won't load properly. I've been able to create a set of code...

Hello, I am wondering if anyone would be able to convert this script for Excel Mac 2011. It allows you to select a .txt file, and then search for values within Column A and replace from Column B within the txt file. This version works for PC versions but not Mac Sub Replace_Text() Dim strFile...

Hi, I'm pretty stuck and no doubt I'll explain this wrong... I'm trying to write a vba scrpt to locate a number pattern that is 3 digits - 7 digits - 7 digits. When found I want to make it a url by adding a web address before it and then adding the original cell value at the end of the url...

Hi i found the macro online and did little changes to it, it works great, but i need an adjustment so that it will match whole word only. Here is my VBA: Sub Multi_FindReplace() 'PURPOSE: Find & Replace a list of text/values Dim sht As Worksheet Dim fndList As Integer Dim rplcList As Integer...

Background: When you press Ctrl-F, the "Find and Replace" window appears and immediately selects the "Find what:" text box. Let's say we are searching for "Dog" and there are three cells with "Dog" in the worksheet (all three cells are exactly "Dog"). When you press the Enter/Return key or Alt+F...