Excel: Extracting text from cell into different columns without using "Text to Columns" function

Hi, I would like to extract the text from a cell into different columns. Eg. In cell I32, I have SLVT920H SLVT921H SLVT923H SLVT935H SLVT978A SLVT910H SLVT911H SLVT979H SLVT982H I would like to extract the text and put them into different columns. End Result: SLVT920H | SLVT921H | SLVT923H | SLVT978A | etc. How should I go about doing it?

This question generated 22 answers. To proceed to the answers, click here.

This thread is current as of June 26, 2014.

For more resources for Microsoft Excel