how do I move text in a cell to a text box in Power Point

**fbarbie** · 05-03-2007, 10:25 AM

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.

**starguy** · 05-03-2007, 10:45 AM

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.

**fbarbie** · 05-03-2007, 11:30 AM

Well, I didn't know about the F5 function you described, so thanks. But that does not solve the problem.

Putting the text into PPT is part of the process for creating a 360 feedback report using Excel and PPT. I export data from a server into Excel that includes numerical and text results. From the raw data in the worksheet, I create tables and graphs for the numerical results. I have these tables and graphs linked into PPT so that each time I have to create a new report, I just pop the data in and all the tables and graphs in PPT are automatically populated.

Except for the comments. I am looking for an automated way to do what I described in my original post. Any ideas?

how do I move text in a cell to a text box in Power Point

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

how do I move text in a cell to a text box in Power Point

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions