I've recently been handed an Excel file to format - 100's of lines. The image below shows you the state of it. This could be a really long exercise if I work through it manually, so I wondered if a macro could help.
My job is to:
Delete the rows where Dot&Dot&Dash are used together. Then;
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).