Tanya Text To Coloums. You can use the left mid right search and len text functions to manipulate strings of text in your data. The key to distributing name components with text functions is the position of each character within a text string.
One of these text to columns allows you to move text from one column into another effectively splitting text entries into two separate spaces. Text to columns will replace your single column with multiple columns using the same data. Too much data in a single column can make your microsoft excel spreadsheet harder to read.
This is the more common scenario for splitting text so we will start with this.
This example causes the third column to be skipped the first column to be parsed as text and the remaining columns in the source data to be parsed with the xlgeneralformat setting. In the convert text to columns wizard select delimited next. Select data text to columns. For example you can distribute the first middle and last names from a single cell into three separate columns.
