Thank you Bruce
I was thinking about joining and splitting in an excel way of thinking,
Gridview does not contain the function substitute which was the key to split the nth word.
Upon staring at the grid I decided to scrap the concatenate method and put together a If / then / and function.

it took some time but I have achieved what I was after.
[img]https://ibb.co/0tLc4Qc[/img]

Thank you
Adrian