Text to columns

You will have a pretty good idea of what all the options in Text to Columns entail in this article

Text to Columns is a tool in Excel that allows the user to split content from one column across multiple columns.