VBA to concatenate a table of data in one cell as a summary

[JEAN1972]

I have a table of data reference which needs to be summarised in one cell

looking a vba code that smash this in a cell.

Sometimes the table is very very bulky.

the answer in one cell should read RS 68150,RS 68283, and so on


RS68150 RS68283 RS68404 RS68739 RS68775 RS68871 RS68933
RS68151 RS68285 RS68405 RS68740 RS68797 RS68872 RS68934
RS68167 RS68286 RS68406 RS68743 RS68798 RS68874 RS68935
RS68168 RS68287 RS68410 RS68744 RS68799 RS68858 RS68942
RS68169 RS68303 RS68420 RS68745 RS68813 RS68859 RS68948
RS68177 RS68304 RS68430 RS68749 RS68814 RS68869 RS68955
RS68178 RS68305 RS68709 RS68750 RS68815 RS68870 RS68956
RS68179 RS68306 RS68713 RS68756 RS68816 RS68906 RS68957
RS68214 RS68334 RS68714 RS68757 RS68827 RS68907 RS68968
RS68215 RS68337 RS68721 RS68758 RS68828 RS68912 RS68969