striker359
Board Regular
- Joined
- Jun 19, 2014
- Messages
- 64
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?
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?