clean data

  1. S

    Clean & Reformat mobile number into excel

    I have three columns with home, business & mobile phone. I wanted to format these numbers so I can filter by country code. Any help provided in cleaning these mobile number. File Attached by name "Test" in google drive:Test.xlsx any help appreciated.
  2. L

    How to get the same data time in multiple time series?

    Good morning the community. I want to get the same data time for each index. Example: 01-01-2009 02-02-2009 03-03-2009 ...................... But, I have this. See below. ABCDEF1Date^FCHI CloseDateBZ=F CloseDateEURUSD=X...
  3. smozgur

    Power Query List.Generate vs. VBA For...Next

    When I read Bill's "How Would You Clean This Data" challenge couple months ago, I thought that it could be easily done by using VBA. However, the article was all about Power Query. I was interested in learning the M language. I was even more interested in comparing VBA with M language. During...
  4. 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...
  5. F

    Best way to automate the reformatting of this?

    I don't know how to best deal with getting my example onto this post, so forgive the copy pasta. Below is an example of how my company's system exports reports in Excel (there is no CSV, or un-formatted option for export). So, the employee's name is sort of randomly inserted at the top of...
  6. P

    Inserting rows in range based on cell value within a loop

    Hello all. I am trying to create a tool that will improve my life by importing, massaging and exporting data in the form I need. So far I have a separate submodule that imports all the data into excel, does some filtering, then combines the data side by side on one sheet. Heres the issue. Each...
  7. D

    Cleaning up data with Get and Transform

    Hi, all! I have a workbook with 12 spreadsheets, one for each year’s financial statements by month. They’re all formatted as financial statements. If I use Get/Transform to clean one sheet, can I use the PowerQuery “program” from the first sheet to clean the others? Or do I have to manually use...

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