Printer-friendly version

Browse the glossary using this index

Special | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | ALL

T

Text to columns

text to columns is a tool used to parse data. As long as there are consistent characters or spaces it's easy to split data into multiple columns. For example, if teacher name is included as "Last, First I" insert several blank columns after the name. Select the name column and use text to columns with comma and space selected as delimiters. The text will split into a new column at any comma or space.