clean data

Hello Excel gurus, I have extracted emails from Outlook to CSV. Sorry if this has been asked before. Column1 (found in A1) Column2 Column3 To: (Address) CC: (Address) BCC: (Address) email1@domainx.com email2@domainy.com email3@domainz.com;email4@domain1.com...

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.

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

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

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

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

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

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