Excel output file: How do I divide the data of a single column into several columns?
Excel’s Text to Columns found under Data in the Command Bar does just that. By defining a seperator character (in this case you should define the seperator character as “|”) Excel divides the data of a column into several columns. For example: The aliases of the gene TP53 are printed in a single box in the output file under “Aliases” as: “P53 |p53 |LFS1 |TRP53”. By using Text to Columns, and defining “|” as the column seperator, each alias is printed in a different column (now each alias would have a different box). It is recommended that this tool be used only for the last column of the output file, otherwise some of the data in the following columns might get “runover”.
