Channel: Excel Campus - Jon

Category: Education

Tags: how to divide one cell into two in excelhow to split cellssplit line break using text to columnshow to separate columns in excelhow do you split a cell in excelhow to separate first and last name in excelexcelpower queryexcel split functionexcel power queryexcel campushow to separate words in excelhow to split cells in excelhow to split one column into multiple columns in excel

Description: In this video, I demonstrate how to split cells in Excel, such as first and last names, that are combined in one column, into their own respective columns. We can spit into multiple columns when there are more than two words, names, or strings in a single column. If you’d like to read the accompanying blog post on my website, you can access it here: excelcampus.com/powerquery/split-column-power-query Here's the link to register in the webinar: webinars.excelcampus.com/registration-blueprint Related Videos: Power Query Overview - Automate Data Tasks in Excel & Power BI: youtube.com/watch?v=vq9AgAtSvQg 15 Shortcuts for Power Query in Excel or Power BI: youtube.com/watch?v=GJQY_28sWHI Split Data into Rows with Power Query: youtube.com/watch?v=tdblfzJ2mEY #MsExcel #ExcelCampus