data clean up

  1. O

    VBA text to columns for a document of inconsistent strings

    I need a macro to help with text to columns for a document of inconsistent strings. Ex strings 123456 *toName 4 100.00 234567 fromName 2 12.000 2 Q12:toName:fromName:1 165.0 183.7 26.0 185.5 112.5 234567 *toName2 2 17.000 345678...
  2. P

    Stuck, Need Help (please). Trying to export unstructured text from PDF to import into Excel separating/placing text into specific columns

    Hello, I'm hoping someone can help with this work project. I have experience with formulas and pivot table and am somewhat familiar with Power Query but apparently not enough for it to help me with this work project. I've been trying to find an Excel work-around for this project to simplify it...
  3. S

    Best method of combining many Excel sheets and workbooks

    Hi So I have a bit of a data cleansing problem for work. I have approximately 20 workbooks all containing approx 25 sheets and I've been asked to combine all of this data into one master sheet. The problem is that whilst all of the sheets have some of the data that we need, the column...
  4. S

    Separating different lines from a single Excel Cell

    I have cells that look like the one below that contain "Class C Part#:", "Manufacturer", "Mfr. Part #", "Pack code" and "your price". I'm wanting to separate the Manufacturer into once cell and the Mfr. Part # into a different cell. I have about 2,000 of these that I need to do and none of them...
  5. B

    Power Query - Data Cleaning Question

    I'm trying to use Power Query to clean up some data and I've hit a road block. My knowledge in power query is very limited so I'm hoping someone with more experience can help me out. I've attached a link with screenshots of the data model (original.png) and the desired outcome (desired.png) I...
  6. P

    Compare data within same cell

    I require a macro code which compares data within same cell and accordingly provides status either "match found" or "mismatch" I work on a discrepancy report and most of the property addresses are same only difference is abbreviations eg. street = st, Road = rd and so on. In the below example...
  7. Y

    Data Clean Up Help VBA

    https://docs.google.com/spreadsheets/d/133HcvG1aBzHgdW2kaw4qeIHvaDaRgC6uc1WGYPIUi5c/edit?usp=sharing Hello, I wasnt sure how to upload an excel file but I need some help with VBA with some data clean up. On the google sheets, you want the 'Data Old' have to look like 'Data New'. The biggest...

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