Copying a particular data from one cell to another Macro

[Janani]

Hi,

Can anybody guide me how to copy a particular string from the cell and paste it in the another cell using macros?Here is my sample data...

data available in cell D : CSRGRID=%5E96006106098%99009109097%5E

I want to extract the data available in between the constant %5E and paste it in cell c. I have recorded the macro and getting the result.Please help me how to generalise the code.Thanks in advance !

Regards,
Janani

 

[VoG]

Hi. I think that this can be done with a formula:

=MID(D1,FIND("%5E",D1)+3,FIND("%5E",SUBSTITUTE(D1,"%5E","~~~",1))-FIND("%",D1)-3)