Excel.jpg

Hey guys,

The attached image shows an example of the data in column B that is highlighted in red that I need extrapolated in seperate columns like C, D, E, F and G shown. Main problem I'm having which goes beyond my scope is the name lengths are different sizes and uniquely identifying how to capture each of the highlighted red parts. If you think you can help me I'd greatly appreciate it!