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,152
Reaction score
2
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,152
Reaction score
2
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