Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting Cell Data Based on Input Mask
I have some messy data which has more text in each cell than I need.
For Example: CompanyName 01-01-118-02W6 Comp Name 01-01-118-02W5 UselessPrefix 01-01-119-02W6 01-02-118-02W6 Useless Suffix A01-01-119-02W6 Company 01-01-118-02W6duplicate I want to extract only the "##-##-###-##W#" portion from each cell (these are surface locations for anyone curious). I want to eliminate prefixes and suffixes of any type, and report nothing if the cell doesn't contain the appropriately inputted string. There are about 30000 records. Any suggestions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting Data from another worksheet based on user input | Excel Worksheet Functions | |||
how to format data with an input mask like ss# (***-**-****) | New Users to Excel | |||
Cell input mask | Excel Programming | |||
Can I set an input mask for a cell? | Excel Programming | |||
Can I set an input mask for a cell? | Excel Programming |