Hello there!

I have spent already quite an amount of hours trying to get a VBA code for an excel Macro.... and it is time to ask for help.

I have a string that will always have 10 characters:

0010412521 - 001 School 04 Lesson 1 Yes 25 No. Girls 21 No. Boys.

I would like a Macro to split this string into 5 columns separated as the example shows.

Since I do not know how to program in VBA I found a Macro I am kindly requesting your help.

If the code could include the fact that I want to run the Macro ONLY on the selected cells it would be perfect.
This is waht I found for that:

Dim SelCell As Range

For Each SelCell In Selection
MsgBox SelCell.Value
Next SelCell

But I cannot figure out how to make it part of the code I need.

Thank you!