Results 1 to 1 of 1
  1. #1
    Join Date
    Sep 2011
    Posts
    5

    Question Unanswered: Sharepoint to Excel???

    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?
    Last edited by GaryElwood; 10-06-11 at 11:20.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •