I have a spreadsheet that has duplicate sentences in all the cells in Column B, and I would like an automated way to delete the duplicate text. For example, cell B1 contains the following text: *See spot run. *See spot run.
I'm thinking a macro could be written to find the first asterisk then the second and then delete everything after the second asterisk. This process would be repeated on every cell in the column.
There may be a better way, but this is all I could come up with.
Everyone's help would be greatly appreciated.
Thank you.
I'm thinking a macro could be written to find the first asterisk then the second and then delete everything after the second asterisk. This process would be repeated on every cell in the column.
There may be a better way, but this is all I could come up with.
Everyone's help would be greatly appreciated.
Thank you.