I need to create a code for formatting a file that I receive from Bloomberg, and has a line break at the end of each line. See below. (I have hundreds of paragraphs like this)
Italy’s debt is forecast to rise to 120 percent of gross
domestic product next year before declining. “I don’t care
about the debt-to-GDP ratio,” Baldassarri said in an interview
on Bloomberg Television in Rome today. “What goes on in the
market and must be underwritten by markets is not the debt-to-
GDP, but the billions of euros of actual debt.”
Basically what I need is for each line (starting from the second line) do a backspace and then insert a space ( " " )
So I guess the code in my loop should be like this:
Selection.TypeText Text:=" "
Does anyone know how I could create a loop to repeat that on each line that I select, or on an entire paragraph?
Please help! thanks in advance!!