i have managed to concatenate the columns with spaces between each word and then extract the first word out with "LEFT" function
formula is:

left({concatenate},find(" ",{concatenate},1)-1)

and also the second word with "MID" function
formula is:

MID({concatenate},FIND(" ",{concatenate},1)+1,FIND(" ",{concatenate},FIND(" ",{concatenate},1)+1)-1-FIND(" ",{concatenate},1))

I have no idea how to extract the third, fourth, fifth and last cell without having a "SUBSTITUTE" formula in gridview.

Thanks again
Adrian