TEXT TO COLUMNS WITH SPECIAL CHARACTERS
In this VIDEO, we will learn how to split text based on one or more characters in the string. Splitting of texts is one of basic tasks in excel. We often get need of splitting names, ids, address etc. from a concatenated text. To do so we target a separator text in the string and use to split each segment of string.