Storing huge data in excel variable and writing it back to xml

[venugopal_p01]

Hi All,

I am having a huge data like below

<?xml version="1.0" encoding="UTF-8"?>

<!--IMPORTPARAMS This inputs the options and inputs required for import operation -->
<!DOCTYPE IMPORTPARAMS SYSTEM "impcntl.dtd">
<!--IMPORTPARAMS This inputs the options and inputs required for import operation -->


Every starting < and ending > is a new line

How to store in Excel with the same format?

and While writing it back to .XML . I need the same format. How to achieve this?

 

[venugopal_p01]

""<sdgbjksbdgjkbsjkdbgjkbsdg and
"<!--IMPORTPARAMS This inputs the options and inputs required for import operation -->"


Format should be like this