I am having trouble to do the following in a VBA macro.

Find cell value in last row and fist column
Copy the string starting from €œ:€� (eg if the cell value is €œabcd: ID€� copy
only ID), in that cell
And paste that to the last column and second row in the same sheet

I know I can use the instr , right and len functions to do get the string
value I am looking for, but I am not able to figure out how to copy that and
paste into in terms of code.
Thank you so much in advance for your help