View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default Deliminating Text

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,