Monday, January 2, 2012

Separating One Cell Text in Columns with Excel

Many times I asked for punctual information but , in contrast, I received more than I had asked for. For example, I just wanted the name of the applications of a computer, but I got much more in just one column. Therefore, I decided to use one Excel feature named "Text to Columns".


In the window that appears with this option you have to select the characters you are going to use as pattern to separate each row in columns, in this case I selected just "Tab" and got what is shown in the image, as you can appreciate the application descriptions will be in a separated column.


Having as a result this.


Once you get what you wanted you can proceed to removing extra columns.


2 comments: