How do I delete part of a text string in every cell it appears in
Try this:
Select your range
EditReplace
Find what: -*
Replace with: (leave this blank)
Click the [Replace All] button
If that goes REALLY WRONG....EditUndo
Does that help?
***********
Regards,
Ron
"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
|