| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
extract cusotmer name from test string
I have long string of text that start with customer name. Immediately after
the text string, it populates either the schedule # (which start with "sch") or master lease agreement # (start with "MLA"). I want to exract only the customer name from it. What will be my formula? Below is a two typical example. A) ABC corp MLA 12667 MMA50-014-0 BSC-73081 B) Black and Decker SCH 303A4 SCH 3A61-COR BSC-15701 Thanks, Dinesh |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| test text string for a comma (,) | Excel Discussion (Misc queries) | |||
| logical test and concatenate(string) | Excel Discussion (Misc queries) | |||
| Test String | Excel Discussion (Misc queries) | |||
| Extract from string | Excel Discussion (Misc queries) | |||
| Extract sub string | Excel Worksheet Functions | |||
Threaded Mode
