Getting a bunch of quotation marks in my data (HTML) when I copy it from Excel to other programs.

[greenmonster15]

I have webpage html source code save in a .txt file from IE.
I'm opening up the .txt in excel in order to extract the information I need.
Everything looks fine until I copy and paste the data into Word, or Notepad.

I get a bunch of quotation marks all over the place. An I opening up the .txt incorrectly somehow in Excel or do I need to write a script to remove all these buggers?

Sample from Excel:

<p align="left"><span class="body"></span></p>

</td>

</tr>

</table>

</div>

<div align="left">

<table border="0" cellpadding="0" cellspacing="0" width="450" class="body">

<tr><td class="Cat_Title">

</td></tr>

<tr>

<td valign="top">

<colgroup><col width="64" style="width: 48pt;"></colgroup><tbody>
</tbody>

Sample after pasted:

</p>
" <p align=""left""><span class=""body""></span></p>"
" </td>"
" </tr>"
" </table>"
" </div>"
" "
" <div align=""left"">"


<table border="0" cellpadding="0" cellspacing="0" width="450" class="body">


<tr><td class="Cat_Title">


</td></tr>


" "
" <tr>"
" <td valign=""top"">"

 

[greenmonster15]

I was able to use =CLEAN() in order to remove all of these and then do a PasteSpecial to paste back only the Values to the original cells. Hope this helps someone else!

 

[Firefly2012]

I was able to use =CLEAN() in order to remove all of these and then do a PasteSpecial to paste back only the Values to the original cells. Hope this helps someone else!

That's interesting - it implies they were not really quotes (as CLEAN doesn't remove quotes AFAIK). Thanks for posting back with your solution!