How about DataText to ColumnsDelimited by "-"

Skip the right-hand column by "do not import"


Gord Dibben Excel MVP



On Fri, 9 Dec 2005 08:19:03 -0800, Chacky
wrote:

I need to delete just part of a text string that will appear in many
different cells.

For example. 1234-DAW001 5678-DAW001 8254-DAW001 etc etc

Is it possible to delete the DAW001 reference in each cell but leave the
number alone, without going into each individual cell. Would this require a
Macro?

I have 1900 cells that have text strings like this and I would like to
change them all to the first 4 digits only