VBA to Split Text from table column to multiple Columns

[hmltnangel]

Hi folks,

Any help as always appreciated. I might be just searching wrong, but I cant find anything I can tailor to my needs. They all refer to specific cell references instead of table. Likewise the Textsplit formula wont work as its in a table and you get a "spill error"

Basically i would like to take text thats in the format belwo, in a table column then split to different columns in the table.

Text Format
Dave Hambleton > Emily Blunt > Bob Sinclar > Tom Cruise (note there is a max of six names here all separated by ">")

These names are stored in table named "Master", Column named "Reporting Line".

They should be output to columns 4,5,6,7,8,9 in the table these columns are called LM1, LM2, LM3, LM4, LM5, LM6 respectively.

I get the feeling this should be so easy, but i cant get it to work.

 

[Fluff]

Likewise the Textsplit formula wont work as its in a table and you get a "spill error"

Simplest (and IMO the best) solution is to convert the Table to a range & then the formula can spill.