Channel: Excel Campus - Jon

Category: Education

Tags: power query custom columncustom column formula power querypower query custom function ifpower query custom functionhow to combine cellsseparate words and numbers in excelexceltext functions power querycombining cells in excelmerge cellsadvanced excel power query - merge queries with 3 lookup columnscustom columnexcel campusmerge queries in power queryif function power query excel

Description: In this video, discover how to merge the text from two or more columns into one combined column using formulas, the TEXTJOIN function, and Power Query. If you’d like to read the accompanying blog post on my website, you can access it here: excelcampus.com/powerquery/combine-text-formulas-power-query 0:00 1. Formula Using Ampersand (&) 3:04 2. Formula using the TEXTJOIN Function 5:40 3. Power Query Related Videos: How to Split Text in Cells with Flash Fill in Excel: excelcampus.com/tables/split-cells-flash-fill How to Split Text in Cells Using Formulas: excelcampus.com/functions/split-cells-formulas How to Split Cells & Text in Excel with Power Query: youtube.com/watch?v=8wXt6KrQOLY Split Cells with Text to Columns in Excel: youtube.com/watch?v=9barqPO2pvg To join our free webinar please follow this link: webinars.excelcampus.com/registration-blueprint #MsExcel #ExcelCampus