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

[striker359]

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?

 

[gwono]

You're correct. My choice of 113 was arbitrary and, strictly-speaking, could fail.

Even better than choosing an even larger arbitrary value would be to replace 113 with e.g. LEN(A1) - which you'll also see often - since no part of a string can be of greater length than the string itself.

I guess I just did a quick mental calculation that the probability of there being a substring of length>113 in the OP's data was so small as to warrant my choice. But perhaps I will start using this LEN construction from now on - rigour in Excel formulas is a desirable quality, after all.

And gwono - thanks for doing my explanation for me!

Cheers

No worries!

I've been getting slowly better at excel and the best way I've found in getting better at it is helping other people out. So the explanation was as much beneficial for me as hopefully it was for the OP

 

[striker359]

Yes it was... i've only begun to get into Excel just 3 weeks ago when I started my temp job... so any opportunity to learn new stuff about Excel is always beneficial

No worries!

I've been getting slowly better at excel and the best way I've found in getting better at it is helping other people out. So the explanation was as much beneficial for me as hopefully it was for the OP