search & replace

Hello Gurus, I have a Binary excel file and want to update a particular column using the unique identifier from an xlsx or xls (get open file) . Do you think it is feasible? Example Binary Sheet: Number Name Country Note 001 Mark Finland Checked 002 Sean United States Example...

Hello, I have a user form like mentioned above and the form needs a searching feature that searches based on certain column text, and then being able to update certain values from selected combobox text & text box values. The search box and command button s are Command button 4 = "search"...

Hello Everyone, I'm looking for a formula that would cause a number value to either increase or decrease by one. Examples of text include: Apr Y0, May Y0, Jun Y1, Jul Y4. The common denominator is that the number is always preceded by " Y". Thanks in advance for all your expertise! Please let...

I am very thankful to the Mr. Excel forum in providing right solutions. my data consists 70k rows and would be helpful if you Provide a solution through VBA Match every comma separated string of column C with Column B at each row level (C2 with B2) If found - it should be remove the word...

I have 2 columns data in Sheet 1 -Column A is a Emp ID and Column B is a text with identified text Keywords to be replaced. Sheet 2- Column A has Emp ID which is a primary key to sheet 1 to compare Once the column A ID is matched in both sheets, then Column B to Column K based on header...

Hi there, I'm struggling with a multiple search and find. I have 26 separate worksheets that are all in different languages. I am manually putting them into one worksheet (not sure if that's the fastest but I'm a newbie to all this). And then I need to get them all to be in English. So... for...

Hi all , and a Merry Christmas! I have been trying to figure out why a piece of vba is not working. I'm searching through a colum of data that has dates and some cells contain W/C and a date e.g W/C 26/12/17. I can get the macro to strip the W/C and the space between the text and date however...

Hi, Can someone help me with a batch search replace script? I get a fixed a list of names in column A every month. I have a fixed list of 100 people but each month, the amount of people reporting is different. Chris Dean John farmer Tony Smith I need to batch search and replace these names so...

Hi, I am working with numerous columns with values such as "4.99 (2.99 CMP)", "3.99 (2.99 CMP)", "2.99 (1.99 CMP)" I am trying to come up with a formula that keeps the information in the parenthesis, excluding the " CMP". For example, if we have the following info: 4.99 (3.99 CMP) I want to...

Hi guys, Hope someone can help/inspire me for an easier way to do this. I've 2 tables. Table 1 being client's data and Table 2 being standard codes used We have a standard set of job titles and its respective codes (e.g. CEO = "0001") assigned for standardization purpose. And companies have...

Hi everyone, I've inherited some data that isn't arranged in a helpful way and can use the group's help. I have data in a column that I need to separate, but the data does not follow a pattern that is easy to correct via delimited text to columns or LEFT/RIGHT. The value within the cell is...

Hello, I am trying to edit a long spreadsheet, I try to search and replace a " ?" with a space before for "?" without space. I am unable, I know I can find "~? " but them will show me all "?". Any one have a better way to replace it? Thanks in advance.

Hello, I have a question that I hope someone can help me with. I have a workbook that contains a sheet called "Foundation Permits" that my company uses to track addresses of new building permits and whether or not we gained that address as a client. Sometimes we end up gaining projects that are...

Hi everyone and thanks in advance for your help. I am not an expert on VBA, so I apologize in advance for any unclear information or misunderstanding. I am looking for a mentor to assist me putting together a form with advanced search options and the relevant result sheet, in order to apply...

I'm not even sure Excel has this capability. I have 2010 and 2016 versions so an answer that works for either is fine. Basically, I have a column that's pure text / general and I want to Bold certain parts of the text based on their contents. Because all the cells are quite similar with only...

Hi, I am new to this Forum and very new to using VBA in excel, so please excuse my lack of proper vocabulary or knowledge. I am a film editor and we have EDLs that show us all of the cuts in a film with time codes in and out - an excel workbook of the movie. We have a separate document...