View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kgiraffa kgiraffa is offline
external usenet poster
 
Posts: 3
Default Extract a text string based on character

I am trying to extract a model number from the title.

Brand New D-Link AirPlus G DI-524 Wireless Router;

I need to extract the DI-524. All of the model numbers have the - charcter,
but are different lengths. How would I use the mid function, not knowing the
length and exact position?

For instance, here is another title:

**New** Acer TravelMate TM4720-6218, 2.2GHz Core 2 Duo;

I need the TM4720-6218 extracted from the text string.

Thank you for your help!