Converting text to columns in Excel 2007
Sometimes we enter data into Excel cells quickly like, for example, a complete name of an employee or contact. Later we find that it would indeed have been more beneficial for analysis purposes to have the full name as first name, middle name and last name. How can we convert the text data into individual columns quickly and easily. Excel offers a great feature known as ‘text to columns to achieve our goal. There are other methods like writing a macro to achieve the same aim. Writing a macro for this kind of seperation of data requires good macro skills and may not be everybody’s cup of tea. The complete process of converting text to columns is described in the video below. Your text data, for example, a full name can be seperated by a comma, a space or a tab. Important to note in the process is that if you do not define a destination cell the original data will be split into columns as shown.
Split names by using the Convert Text to Columns Wizard