Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Extract text from a string | Excel Worksheet Functions | |||
Excel-Match 1st text character in a string to a known character? | Excel Worksheet Functions | |||
Extract String based on condition | Excel Discussion (Misc queries) | |||
want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions |