Recent Comments
Patrick O'Beirne, Ex… on Excel formula to test if a wor… Peter Bartholomew on Excel formula to test if a wor… Rick Rothstein on Excel formula to test if a wor… Patrick O'Beirne, Ex… on Excel formula to test if a wor… Peter Bartholomew on Excel formula to test if a wor…
Monthly Archives: Oct 2021
Power Query infer data types with Table.Profile
The Power Query UI automatically detects column data types and performs the transformations for you. Typically these steps look like this: However, when I am calling Power Query M code from VBA ( see my previous posts) to open any … Continue reading
Excel Virtually Global 2021
I am one of the 48 speakers at a 48-hour Excel extravaganza online on Oct 12 and 13. It’s FREE but you are encouraged to make a donation to charity to reflect the value to you of the content you … Continue reading
Posted in Uncategorized
Tagged CSV, Data, Excel, ExcelVirtuallyGlobal, StructuredData, Unicode, VBA
Leave a comment
Patrick O'Beirne @ sysmod 