Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chacky
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Vito
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
getting value from a cell into another cell behind a text string Xianbo New Users to Excel 1 October 19th 05 05:51 PM
Text disappears when word wrap is used Mark_GS1CA Excel Discussion (Misc queries) 12 October 17th 05 12:44 PM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
How do I test a cell for part of text East London Excel Worksheet Functions 1 January 26th 05 12:36 PM
Cell set to wrap text and blank line -- fix? Fred Holmes Excel Discussion (Misc queries) 0 January 25th 05 08:10 PM


All times are GMT +1. The time now is 12:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"