VBA solution to extract/separation of strings, copy and paste

Hello all,


I would like to kindly ask for help in terms of rather simple data manipulation where I need to add two pieces of selected content from one column to another using the matching structure and delimiter of the destination cells. One string should be added in front and one behind the existent string. Please note I would like to apply this to all the records in the respective column. Attached please find the example.


Your help is much appreciated.