Excelguru.ca - Powered by vBulletin
  • Register
  • Help

  • Home
  • Products & Services
    • Training
    • Monkey Tools Add-in
    • Monkey Tools Account
    • Books & Other Products
    • Private Courses
    • About Us
    • Today's Posts
    • FAQ
    • Calendar
    • Community
      • Member List
    • Forum Actions
      • Mark Forums Read
    • Quick Links
      • View Site Leaders
  • Blog
  • Forum
    • Excelguru Forums
    • What's New?
    • Today's Posts
    • Forum Guide
    • Forum FAQ
    • Supported BB Code Tags
  • Knowledge Base
  • Contact Us
  • Advanced Search
  • Home
  • Home
  • Knowledge Base Home

  1. If this is your first visit, then welcome! Be sure to check out the FAQ by clicking the link above.
    Register here so that you can post in the forums or comment on the articles.

  • Monkey Tools
  • Knowledge Base Articles By Category

    Access - ADO (4)
    Access - SQL (4)
    Access - VBA Programming (10)
    Downloads - Games (1)
    Downloads - Learning Aids (11)
    Downloads - Utilities (9)
    Excel - ADO (4)
    Excel - Charts and Data Visualization (1)
    Excel - Formulas (8)
    Excel - General Tips (36)
    Excel - Interactive Pages (9)
    Excel - PivotTables (12)
    Excel - Power Query (3)
    Excel - PowerPivot (7)
    Excel - SQL (4)
    Excel - UDF (7)
    Excel - User Interface Customization (2)
    Excel - VBA Programming (49)
    Excel - WebApp (4)
    Internet Explorer - VBA Programming (1)
    Novell Groupwise - VBA Programming (2)
    Other - General (1)
    Outlook - General Tips (5)
    Outlook - VBA Programming (7)
    PDF Creator - VBA Programming (11)
    Power BI (3)
    PowerPoint - VBA Programming (7)
    Publisher - VBA Programming (7)
    Syndicated Articles (7)
    Word - VBA Programming (8)
  • Bob Phillips

    There is no available content written by Bob Phillips
  • MVP Logo
  • Recent Forum Posts

    pinarello

    Extract data from 1 column in txt with Power Query

    It is probably not a big problem to split the vertically arranged vendor blocks into individual columns, but in the end there will be too many columns...

    pinarello Yesterday, 11:38 PM Go to last post
    p45cal

    Help with Power Query

    Worst case, change the extension to .zip and tell us what it should be changed back to (or actually zip it up)....

    p45cal Yesterday, 09:02 PM Go to last post
    kboakye129

    Help with Power Query

    @ P45cal
    My file is in csv format . Can I attach? the system is not allowing me to attach the file
    Anyway, I am grateful for your help. I...

    kboakye129 Yesterday, 07:35 PM Go to last post
    Zigfreud

    Extract data from 1 column in txt with Power Query

    I have some files from SAP system. They are exported in .txt. They have the same structure. The idea is to arrange the data into a more user friendly...

    Zigfreud Yesterday, 07:07 PM Go to last post
    amyfb

    ListFillRange - how to specify range

    'Variable not defined' error is what I get when running that code exactly as i copied from the web.

    I wish I could understand how the code...

    amyfb Yesterday, 04:32 PM Go to last post
  • Contact Us
  • Excelguru Forums
  • Archive
  • Top
All times are GMT +1. The time now is 02:09 AM.
Powered by vBulletin® Version 4.2.5
Copyright © 2022 vBulletin Solutions Inc. All rights reserved.
Pre-Defined Posts provided by Post Templates v1.6.1pl1 (Free) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
Thread / Post Bookmarks provided by Thread / Post Bookmarking v1.2.0 (Free) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
Copyright © 2004 - by Excelguru Consulting Inc.
Gravatar by 1e2.it