View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
NicoleS NicoleS is offline
external usenet poster
 
Posts: 27
Default Deliminating Text

I never thought of this. This would work well when I have a long list of part
numbers that vary only with the color code at the end. Thanks :)

"Dave" wrote:

Try this...

Go to Edit, then click on Replace...

Put in the Find - 1234-AB
Put in the Replace with- 1234-AB

Then click, replace or replace all.

If this does not work let me know and I will attempt to fix it by
delimination.
-D

"NicoleS" wrote:

I need to deliminate text, but not all of it.
Example: Let's say this is a part number:
1234-AB-20GQ

If I need to keep the 1234-AB together, and just drop off the 20GQ... Is
there a way to do that?

Currently I use deliminator, set it to deliminate hyphens (-) and then
concatonate the pieces I need back together.

Thanks,