Fixing Bullet Lists with VBA Macro

Originally Posted by craig.bickett

Okay, I get why that works that way. Thank you. That pretty much solves my problem.

There aren't many lists using numbers, so I'll just edit those manually.

Instead of " " in the split code for double space you would put chr(10) without quotes:

Split(sht.Range("A" & i).Value, Chr(10))