unwanted

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...

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...

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...

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...

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...

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...

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...

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...