Power Query trick in Excel
Split Text in Excel Without Delimiters Using Power Query LinkedIn Facebook X Reddit WhatsApp Split Text in Excel Without Delimiters Using Power Query Most Excel users rely on formulas or delimiters like commas and spaces to split text. However, Excel’s Power Query allows you to separate values cleanly without writing a single formula. How It Works Select your data and convert it into a table. Navigate to the Data tab and choose From Table/Range. Load the data into Power Query Editor. Use the Split Column or case-based transformation. Close and Load to apply the changes back to Excel. This method is ideal for repeatable tasks like audits, reports, and large datasets where consistency matters. Read full article on Discover Talent Subscribe on YouTube Excel Audit Course Discover Talent Website Join the Discover Talent Community LinkedIn LinkedIn Group Instagram Threads Pinterest Quora GitHub Reddit SEO T...