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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I delete part of a text string in every cell it appears in
One possibility is to add a column (perhaps temporarily) and enter the formula =Left(A1,4), where A1 contains the first item to convert, then you copy down the formula as far as needed. Then you can hide the original or you can Copy - Paste Special Values your new results over the originals and then delete the temporary column. -- Vito ------------------------------------------------------------------------ Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182 View this thread: http://www.excelforum.com/showthread...hreadid=492215 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I delete part of a text string in every cell it appears in
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 |
Reply |
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) |