none
Losing Rich Text Bullets on Export to Excel 2010 RRS feed

  • Question

  • Greetings--

     

    I have a ShaerPoint 2010 custom list that includes a Rich Text multi-line column, in which my users enter descriptions of work items. After data entry is completed in the SP list, I export the list to Excel so as to be able to print the list info with formatted headers/footers and other information.

    Unfortunately, I am finding that "bullets" applied to text in the rich text column in the SP list, do not appear as expected when exported to Excel. For example, text that should look like this in a single block of text--

    • Item 1
    • Item 2
    • Item 3

    ...comes across into Excel looking like this:

    Item 1Item 2Item 3

     

    Has anyone else run into this sort of problem? And better yet, come up with a clever solution?

     

    Thanks in advance!

    Thursday, October 20, 2011 10:36 PM

Answers

  • Hi eculver3,

    Your problem is quit simple, this is happening because the bullets functionality is not available in the excel you are using.

    so if you export list to excel it will not show bullets, other things like bold,italic,font, etc will work.

    Hope this will help you.


    Thanks.... ________________ Baba
    Friday, October 21, 2011 5:40 AM