I have a SharePoint List with a column of type 'Multiple lines of Text'. Then I copy a Excel spreadsheet content into the List using
Edit in Datasheet. Later, when I use a HTML text-area to display the text, it will always include the
<div><font face=Calibri size=2> ... ... </font></div>.
Is it possible to stop SharePoint from adding other HTML coding beside the ones that I have in my Excel file?
I have the following excel file:
==================== | Alice and John | | Mary and Peter | | June and Johnny | ====================
If I copy into the SharePoint list using the
Edit in Datasheet, and then later using a HTML text-area box, it will display as follows:
================================================================ Couple: | <div><font face=Calibri size=2> Alice and John </font></div> | ================================================================
But what I wanted SharePoint to display was this:
================== Couple: | Alice and John | ==================