Tuesday, May 3, 2011

Parsing cells in Excel

In the case you need to parse the cells in a column or multiple columns in Excel 2003:


Select the cells to be parsed.
Click Data/Text to columns.
1)
If there is a separator symbol that could be used for parsing:
Select Delimited,
Type in the symbol that wil be recognized as a separator,
Choose Destination cell for the output




The resulting output for the given example:



2)
In the case the cells' content has fixed width one can set a position of a separator:
Select Fixed Width,
Place the separators where needed to split the cells


The resulting output for the given example:


No comments:

Post a Comment