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