unwanted

  1. R

    unable to remove paragraph-special characters from string values

    I've loaded a data set from our accounting database, into an array. The accounting database users appear to be accidentally pressing the enter key in the description field, saving the data afterwards. When I dump my array containing all of this information, into an excel sheet, the...
  2. G

    efficient code to remove unwanted rows

    Hello,, i am currently using the folliwng vba to remove unwanted rows, however as the data grows the refresh time is not very fast. iLastRow = Cells(Rows.Count, "g").End(xlUp).Row For i = iLastRow To 1 Step -1 If Cells(i, "j").Value = "xxx" Then Rows(i).delete...
  3. jluangrath88

    Excel VBA to Delete Unwanted Data

    Hi fellow Excel experts! I need a bit of help figuring this one out. I need a VBA code to delete some columns and rows that have unwanted data. Let’s call this sheet, Sheet1. Sheet1 has Columns A to L. However, I only need Column A, B,C,D,H, and J. I want to completely delete Columns E, F, G...
  4. S

    remove unwanted characters from a certain range

    Hello, on this example I am looking for the best way to remove the unwanted characters and leave just the date in a certain column. Thanks for any help. this range would be in starting in B2, and can be any number of rows. Results could be in Column C B9048764-001 on 10/10/17 B9048764-002 on...
  5. C

    Unwanted space between letters in a word

    Hello all I have utilized the formula =TRIM(CLEAN(SUBSTITUTE(A2,CHAR(160)," "))) which has worked perfectly for a large messy data set except for those text strings that have an unwanted space between the letters in the one word. eg Tree Top Pro perty where the word should be property and S...
  6. 0

    Unwanted Excel screens appearing issue

    Hi Guys, Hope you are going great. I am getting this issue in my Excel file. Whenever I run macro through various buttons inside; after the run is complete there is unwanted excel screen overlapping in current screen. When I do page Up/Down it goes away. This is very frustrating as we cannot...
  7. M

    Groups turn on, autocalc turns off every time I open s/sheet

    I have moved to a new computer, and my s/sheets are getting messed up. EVERY TIME I open my main work s/sheet, Groups is enabled and Autocalc is turned off (from Automatic to Manual). Autocalc is set to Auto in Options. Totally screws up my s/sheet, and it is almost unusable. Using Excel 2007...
  8. R

    Excel changes the size of my chart by itself

    I'm having a trouble with chart size. In some of my charts, while running my macro, Excel changes automatically the size of my chart, turning it difficult to read (it is not an automatic way to make it more readable). While debugging it does not occur. I found a way to avoid this while running...

Watch MrExcel Video

This Week's Hot Topics

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
Top