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

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,