I am having a problem importing Sharepoint data into an Excel spreadsheet (Excel 2007) Some of the fields in the sharepoint site are memo fields with a Text Format of "Rich Text". (These memo fields contain a lot of formating. i.e. Bold, underlind, bullet points, etc.)
The problem is, is when i import the data to Excel it includes all the format characters! Why is does it look ok if i cut and paste the data but not when i import?
I have used numerous ways to import with allways the same results?
HOW CAN I IMPORT TO EXCEL AND RETAIN THE FORTMATTING OR REMOVE THE FORMAT CHARATERS?
Does Excel support Rich Text formatting it it's cells?