Trimming Bulleted list from .docx file leaves symbols

[cworkman123]

Hello,

I've written a macro to identify bulleted lists and then remove said bullet. However, every time the value of the bullet is deleted a line of random symbols are left behind.

The bulleted list needed to be trimmed:
bulletList.JPG

This is the value the bullet is given within excel:
bulletListExcelValue.JPG

Notice the bullet is given a value of r.

In my VBA Macro I search for a value of r and then trim accordingly.

Here is my code:

Please Login or Register  to view this content.

I've stepped through the code and it seems to locate the value correctly, but when it trims it leaves behind a weird set of symbols.

The weird set of symbols:
bulletListSymbols.JPG


Any idea what is happening here?


Thanks,
Channing

[JasperD]

Why are you trimming twice?

Try this:

Please Login or Register  to view this content.

[cworkman123]

JasperD,

Thank you for your response. I've tried your code, but im still left with odd symbols after trimming. The thing is, the sentence that is left behind in the formula bar after the trim is actually readble. It's only when I'm viewing it in its cell.

Thanks,
Channing

[JasperD]

Please Login or Register  to view this content.

[cworkman123]

wow that makes perfect sense! Thank you, sir.