I have a column of data that contains "Franklin Fund - Dividend Earned" in
each cell.

Is there a way to remove the "- Dividend Earned" from each cell without
manually editing individual cells?

MANY years ago there was a spreadsheet called QuattroPro which, IIRC, had a
way to highlight a 'column within a column' and delete it.

Of course I can do it manually but it will be a big time consumer.

Thanx!

Vic Baron



--
There are 10 kinds of people - those who understand binary and those who
don't