Please assist with a split text to columns formula

Elso

New member
Joined
Jun 30, 2022
Messages
3
Reaction score
0
Points
0
Excel Version(s)
2013
Hello

I am getting kind of lost in the syntax to achieve splitting text to columns.
I think the attached test sheet will explain what I am trying to do a lot better then trying to explain with words.

View attachment text split test.xlsx

Thank you
Elso
 

p45cal

Super Moderator
Staff member
Joined
Dec 16, 2012
Messages
2,169
Reaction score
11
Points
38
Excel Version(s)
365

Elso

New member
Joined
Jun 30, 2022
Messages
3
Reaction score
0
Points
0
Excel Version(s)
2013

p45cal

Super Moderator
Staff member
Joined
Dec 16, 2012
Messages
2,169
Reaction score
11
Points
38
Excel Version(s)
365
Use Text to Columns:
2022-07-01_171324.png
2022-07-01_171052.png

2022-07-01_171156.png

2022-07-01_171542.png

and finish up with:

2022-07-01_171639.png
 

Elso

New member
Joined
Jun 30, 2022
Messages
3
Reaction score
0
Points
0
Excel Version(s)
2013
Thank you, but I am looking for a formula that will do what the wizard does. Splitting needs to be done as items are selected.
 
Top