removing

Hello All, I have a userform with a combobox that on Initialize the combobox is loaded with about 23000+ items I have a checkbox where it will remove all of them currently 1 by 1 and load another list of only about 200 items When the checkbox is unchecked it will reverse it by removing the...

Hi all, I'm hoping someone can help me! I'm working with some data where each cell contains multiple entries (which are unique references). Essentially I want to compare A2 and B2 to show how many entries should still be live. I can get a numerical view of this in C2 by using...

I have this problem, I have three columns with data: A B C 1 98 98 ? 2 98 3 12 4 98 5 02 Column A has the serial numbers of all my products, column B the ones that have been sold, and column C I need to...

I am doing some data comparison/testing and need a way to remove trailing spaces from the end of each cell. The number of spaces at the end could vary depending on the data. Clean/TRIM is removing spaces in the middle that I must retain. I have also trying using SUBSTITUTE to replace but again...

Hey, As my last post regarding is not addressed I am posting this again. I want to clean (removing non-printable character) and trim (removing extra spaces at the beginning and end) my data in selection within a column. As the clean function also remove alt-enter, I want alt-enter to be...

I need help in removing periods from a series of cells. Example: <colgroup><col style="mso-width-source:userset;mso-width-alt:8618;width:202pt" width="202"> </colgroup><tbody> Columbia-Barnard......................... Duke...

I have a cell that contains 2/1/18..2/28/18 and I would like to remove everything to the right of the .. including the .. so my new cell would be only 2/1/18 I can not do it by removing a number of characters because I have instances with more characters (ie: 12/1/18..12/31/18) Appreciate the...

<tbody> Description Date Value Item 1 2016/01/26 0.01399 Item 2 2016/07/18 0.17513 Item 3 2016/06/13 0.02468 Item 1 2016/08/15 0.01452 </tbody> This runs down thousands of rows with various dates and values and descriptions in a sheet called "Data Capture". The descriptions...

Hello, I would like to inquire about the possibility of removing duplicate fields from entire sheet. The condition is the duplicates must on the row basis which means that data in a set of columns are repeated together so their rows needed to be cancelled. Thanks so much

Hello, I need VBA code please that will copy + paste the formulas (removing the formulas), except for cells with "#N/A". Many thanks.

Hello, I am having an issue with my IF statement below involving removing columns and that it ends up not removing all the columns it should. When I do a debug.print it finds the correct columns to remove however when it actually runs it's not removing them all. I figured out it's because as it...

Hi. I have a combobox in a form that I currently have removing duplicates. I would like it to also filter the results by a combobox from another form that this form launches from and stay sorted. So, if column A = X and column B = Y, fill the combo box with column C while removing duplicates...

<style> <!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";} Page {margin:.75in .7in .75in .7in; mso-header-margin:.3in; mso-footer-margin:.3in;} td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:black...

Hi guys!: I need really need your help for this. I was looking for a macro that could automatically detect and remove 2 letter words (for example: or, if, hg, wa, rt, op...) in a selected range (it will be almost always in column A) Also, i wanted to put this macro some words that it should...

So I have an annually acquired list of addresses that have backup generators onsite, along with contact info and company names, etc. There is a unique identifier, which is the address of the building, since these generators don't move locations often. Pretty much never. I have the list acquired...

Hi. If I have a string including Alphas and Numerics, is there any way of pulling out just the numerics. e.g. Cell A1 = "A78SD9F8G" and I want cell B1 to return just "7898" (ie removing all the Aphas) Is there a quick formula that can do this? Any help would be appreciated. Thanks in advance.

I need to remove all the alpha text in a cell using a vba macro. for example, cell A1 reads: " january rate is $.045 " Whereas I would like it to be " $.045 " Thank you in advance