Sometimes we enter data into
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.