Quote Originally Posted by fbarbie
Some of the columns of data I export from a server have text (comments) which I put into a bulleted textbox in PowerPoint. Right now, I have to do this manually, getting rid of cells that are empty, then manually pasting into a bulleted textbox in PPT.

Is there a way to automate taking text from a column of cells, removing/skipping blank cells and having it end up as bulleted items in a PPT textbox? For extra points, is it possible to get the comments to continue in a new text box in a next page when there are too many comments or they are too long?

Thanks for your help.
Hi
Select the column which contains data alongwith blank cells.
press F5 then Special button and select Blanks. (it will select blank cells)
then right click on any selected cell and click Delete and check Shift cells up option and click Ok. (blanks are deleted now).

copy the data (without blanks now) and paste in MS WORD, after pasting check Keep Text Only option from smart tag apprearing in the right lower corner of the last data entry then apply bullets and paste into Power Point.
(You can also apply bullets in PP as well).

hope this will solve your problem.