| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I delete part of a text string in every cell it appears in
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| getting value from a cell into another cell behind a text string | New Users to Excel | |||
| Text disappears when word wrap is used | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| How do I test a cell for part of text | Excel Worksheet Functions | |||
| Cell set to wrap text and blank line -- fix? | Excel Discussion (Misc queries) | |||
Threaded Mode
