I am proficient with excel macro/VBA development, I can deliver the macro to split the text into corresponding columns as described in your specification, please message me if you want to discuss further, looking forward to provide a quick turnaround solution and work on your project.