find & replace

Hi, First of all I am trying to replace a part of a string in a list of data e.g. EXP4200-1 EXP4200-2 EXP4200-5 EXP4200-25 EXP4000-2 EXP4000-3 EXP3080-12 EXP3080-105 EXP3080-106 ... I want to delete (or replace with "") the 'EXP####-' part of the string, however I dont know how to use the...

Hello, I have an issue where I need to change cell references in my formulas. I have hundreds of formulas like the following one: =IF(AND(Calcs!HQ54, Calcs!IB54=FALSE), VLOOKUP(Calcs!$EE54, $B$16:$R$50, 15, FALSE) + Calcs!DK54, Calcs!DE54) ) For all references to cells that are in the Calcs...

Good Morning, I am currently tryin gto create a Sales Pipleine userform. I have created it to save the data (40 data fields) entered into the form to an excel sheet named "raw data". I have added a search form also which will find a previously entered form and recall the data to the...

I have a list of employee last names and and employee number both in separate columns. I have a few employees that have the same last name. Is there a way to look up certain employee numbers in one column and then replace the value of a different column. So look up the employee number then...

Hi Guys, I am looking for VBA code to search for multiple entries and if those multiple entries are "True" then the code will pass the Answer in a Textbox as "Hired" or "Available" Basically I am trying to develop a little program for Hat Hire whereby if I enter the Date of when the customer...

I am looking to use excel 07 vba to find and replace into word and apply bullet point formatting to specified text. Here is an example of my code: Dim wrdApp As Word.Application Dim wrdDoc As Word.Document Set wrdApp = CreateObject("Word.Application") wrdApp.Visible = True Set wrdDoc =...

Hey all, I am looking to find text in word and replace it will a cell in excel. That i am able to do perfectly. However I would like to format the data into bullet points. Currently i am using a variable in word to perform the find/replace. That variable maps over as such...

Hey all, I am running into this error which is making things difficult when trying to find and replace. The error is: Run-time error '5854': String parameter too long I take it there is a character limit when using the find and replace and if there is a way around it, it would be GREAT...

Hey all, I am able to find in excel and replace a variable in word perfectly fine. A new issue i just ran into is when trying to find and replace a variable that is in either a header/footer or a text box (i.e. Title box) Here is my current code that will not find/replace variables in...

I really need some help from you guys that are good at excel. I am really green to excel. I know my way around it just enough to open it up. Ok, I know a little bit more but not much I swear. Here is my issue and problem. I have 2 excel files. both contain names, phone numbers and email...

Hi All I am wondering if anyone can assist me. I have a situation where I have a table with about 2000 rows. Table A. I have another table with 100 000 rows. Table B. There is a column in table B that has a Description. I need to check if any one of those words in the description column...

Good Morning, I have an excel sheet that uses the Bloomberg Ad-in. We need this sheet to be "live" (which uses one formula) and historical (a different formula) the two formulas look like this: Live: =BDP("ticker","px_last") Historical: =BDH("same ticker","px_last",date,date) *all of the...

This is hopefully easier than I'm making it. What I'm trying to do is edit my bank statement before importing into Quicken via excel. I'm looking for what to put in the 'Find' window of the 'Find and Replace' dialogue box, which will allow me to delete "CHECKCARD xxxx". These x's represent...

Hi Folks, I want to use Excel to perform some types of text search and do display the results as described below: For example, I have an excel table with two columns (A, and B). column A contains a list of book names, and cells in column B are synopsis of the respective books (which is a text...

Hi - I have a 1000+ list of participants and their organizations. I want to replace the value i column B with the Unique ID in column D, IF and only IF it is a match between column B and column C: I´ve two problems: 1) My VBA-code is case sensitive which is wrong. Should be => case...

This just started happening a couple months ago, not sure what changed. I have multiple journal entry files that I complete weekly, and I used to be able to keep the same find/replace values to update all files each week for the current dates. Now whenever I get into the next file I'm working...

Do you know of a formula or VB code that I can tell it to find all instances of an assembly number ex. “10651457-011” and replace it’s build qty in the cell next to it? So far, I can use an input box to gather what assembly to look for and another input box to gather what I want the build qty...

I want to be able to part of string that was found with wild cards, but maintain the values that the wild cards replaced. I have data that may contain strings of the following form xxx, [abcd, efgh], xxx I want to be able to replace this with the following string xxx, [abcd/efgh], xxx...

Hi everyone, I apologize if this is a nubie question. I have a user that when doing a Find & Replace, it doesn't find, even though the text is clearly in two fields (very simple sheet). The same spreadsheet on my PC finds the two results perfectly. I've checked her Find & Replace settings...

I am trying to remove all the extra text around last part of the URL. For example, the first one I just want "16 flavor packets variety pack optimum gold standard 100 whey protein powder" as the final text. Really would appreciate the help. Thanks!! <option...