#find

  1. Z

    Find and replace values with a dash (-)

    I have a bunch of excel files that contain some values in column D Whenever there are values in this format, with a dash: F12314J-67" (yes with an inch mark at the very end), they need to be replaced with something like : F12314J I've been working on this for a while now and my code so far is...
  2. Z

    Search for a value in a column, then modify all the cells contain this value by adding a number to the end

    I am fairly new to VBA. I need to create a macro that searches the entire column K for keywords " C Box", for any cell in this column that contains these keywords, I need to add a numerical value to the end of the text (this numerical is always in the same row as the cell that contains the...
  3. M

    Count value when the value is a merged cell

    Hello, I'm a newbie to type VBA code. Recently, I would like to create a series of VBA code in order to accelerate work. Now, I have faced the problems below: 1. I would like to count the number of "LTG" which has 3 merged rows only.(shown in the uploaded image) 2. About the Find Function, I...
  4. N

    FIND SPECIFIC VALUE...IF FOUND RETURN SPECIFIC VALUE

    I have a column with 3500 addresses. I need to search the column for things like Unit?? or RR?? or PO Box??. The addresses are not all entered the same. Some have the Unit at the front and some at the end. Same with PO Box. If it searches using a wildcard like Unit???/Unit* and finds the value...
  5. R

    Copying specific cells from multiple files

    Hi ALL!! I have voyage data for few ships telling me how the ships performed in each voyage.The database is divided into two halves in the same worksheet i.e when the ship is empty and when the ship is full. Although I am able to extract the whole data but i want only specific data, lets say...
  6. A

    VBA Help: Replace Text in different Sheet

    Hi all, I'm new to VBA and while trying to learn this new language, need to figure out a way to do something for work ahead of my current skill level. I have two sheets, in each there are hundreds of rows of the three columns listed below (I'm only using 1 row but would need this using a...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top