How To Split Cells With Text To Columns In Excel

In this video, I show you how to use Excel’s Text to Columns feature to split full names into first and last names.

Related Videos:

How to Split Cells & Text in Excel with Power Query:

#MsExcel #ExcelCampus
00:00 Introduction
00:17 Duplicating a Column
02:48 Pros and Cons
03:44 Disadvantages

[patdwyer]

Thanks, previously transferred them separately. Had never used "Text to column".

[wayneedmondson]

Hi Jon. Text to Columns feels a little dated these days, given what can be done with Power Query, all the great text functions and even flash fill. But, always nice to know multiple ways to get things done. Each has its own best use case. Thanks for sharing :)) Thumbs up!!

[marwanwali]

I hav a sheet with fourth names but when i split it, the names don't split ever each on name but all forth names spilt together...what is the problem please ?

[ProfYC]

Thanks for that video. If we want to reverse this process and place 2 columns or even 3 columns into 1 column. Is that possible?

[najeebrahman]

I know it's perfectly. But I need to Make automateD sheet with data

[Sherazkhan-llsp]

How to do separate large data into separate multiple sheets?

[AksirNotes]

There are some first names that have space between them, how should we deal with those?

[dhanbriones]

hello i have a big problem on my project.. can you please help me?