If we want to split data in one cell into many columns, we can use the built-in Excel tool, which is called “Text to Columns”. The most common problem is the desire to separate the name and surname in one column and here I will show how we can do this. Sample data below: In …
