Thanks for the feedback.

DataText to Columns can be used for many functions.

Did you know that running bogus text dates through T to C can convert them to
recognizable dates in most cases?


Gord

On Sun, 27 Apr 2008 09:33:21 -0700, "Vic Baron" wrote:

Aha! That's the command I was looking for. Good to know! Thanx!

"Gord Dibben" <gorddibbATshawDOTca wrote in message
.. .
DataText to ColumnsDelimited byOther. Enter a hyphen(dash) then Next

In this window select the second column and choose to skip it then Finish.


Gord Dibben MS Excel MVP

On Wed, 23 Apr 2008 10:22:43 -0700, "Vic Baron"
wrote:

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