PDA

View Full Version : Formatting text in table?



Drew138
10-14-2010, 05:47 PM
I need some help as I'm extremely new at VBA but I've got a report in excel that I need to put into PPT and one of the cells needs to be formatted with bullets. Most everything just copy / pastes into PPT fine, but I can't get the column with bullets to do what I need.

The last column has text that resembles:

## Line 1 ## Line 2 ## Line 3 ## Line 4

I need to the text to look like this:
This is a test of what I'm looking for in this Line 1 example
This is a test of what I'm looking for in this Line 2 example
This is a test of what I'm looking for in this Line 3 example
This is a test of what I'm looking for in this Line 4 exampleI also need the bullet and the wrapover text on each line to be indented to the same indent.

I hacked something togther in excel VBA that finds and replaces the "##" and inserts a bullet and a line space, but it's useless in PPT and I can't find anything to help.

Does anyone have any tips on how to get started with this one? I'd be willing to donate ($) if someone wants to work with me to solve this one!

Thanks

Drew