I've recently been handed an Excel file to format - 100's of lines. This could be a really long exercise if I work through it manually, so I wondered if a macro could help.
My job is too:
1. Delete the rows where Dot&Dot&Dash are used at the beginning and together. Then;
2.Go through the list again and remove the remaining Dots&Dash characters without deleting the rows.
I'm hoping that this should then leave my new formatted list aligned to the left.
Anyway if any of you can point me to the correct things to put into a suitable Macro then it would be really appreciated (and save me hours of work, as I feel this isn't the only sheet they have formatted in this way).
Here's a link to an image of a little bit of the fiole I'm working on (Thanks Hui for the advice).