clean

I'm using Microsoft Excel 2010 on Windows 7 64-bit. I have a worksheet where I have different products with their prices from 2 different stores. I have 3 worksheets altogether - this front one where I can see the stuff I need, one for one shop, and one for the other shop. For each product I...

I'm sure this surely happened to other people but can't seem to find anyone who knows how to totally resolve the issue. I have a workbook that has data from an outside system (copied in as Paste+Special "Match Destination Formatting") yet when I try to run code to perform a lookup/match...

Daily I download a file that needs to be modified for review. When I inherited this, there was already a macro created that does this. The problem is because there are thousands of records, it takes a long time to go through it's loop. I've played with making a change in the macro that would...

hi, I'm using CleanTrim function wrote by Rick: Trim all Cells in a Worksheet - VBA but I got Run-time error `1004` Application-defined or object-defined error after 1774 recrods my code below Dim sourceWb As WorkbookDim LastRow, x_rows As Long Dim i As Long Set sourceWb = ActiveWorkbook...

Hi! I would like to sort the list of variables into each of their own rows somehow, but I don't even know where to start! Any help at all would be awesome! Thank you! <colgroup><col><col><col></colgroup><tbody> WEL02B 5 Mont Street CALORA NORTH NSW 2211 DOB: 13/01/2011 ABN...

Hello everyone :):) I have a pdf file...I've converted it into excel....everything seems fine after conversion but the data has hidden spaces and quotes. For example something is written like AB1900 in original file, when I copy it and paste it in search dialog box it appears like "AB1900...

Hi there, Happy new year to all. I am using the following code to clean-up cells before processing data. I was wondering if anyone had ideas on how to speed up the code (besides the screenupdating and manual calculation, of course). Thx ----- For x = 6 To LastRow Range("D" & x).Value =...

I have a need to dedupe a keyword list in Excel 2010. Easy enough. But some of the keywords have "" in them. First off how can I remove the quotes from every cell in a column? Then when I goto dedupe I need to count how many times a keyword was found to be a duplicate. The keyword list is...

Hello all, first time poster here; not sure how I've been operating without this forum... Any help with this would be greatly appreciated. I've been working with a large data set for quite a while now; attempting to get multiple vertical text strings into single rows to shrink the total number...

Hi All, I have a data set of about 20k rows, exported from a not so friendly DB, that has blanks all over. It is causing havoc with my VB and Dates! Can anyone help me to TRIM all the data. Ideally some VB just to pop into the clean up loop I have on for formatting. Any advice would be...

I am trying to make a download from a web report to Excel so that it can be made into a Pivot Table. I am looking for VBA code to examine row after row of a field, keeping records that have the first letter of Z or the first 2 letters of Ty. These fields with Z and Ty have blanks preceding...

Guys, Pardon my ignorance but these got me stumped. I've received an excel file which contains name and personal id both keyed into the same cell separated by "enter" key. I've used clean, proper and right functions separately to get to this sample output:Excel WorkbookBCDE2AZURA BINTI...