| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text function
i have a database which i need to extract the supplier name and they are not
in same order for example RPO-09393-Supplier AAA 980-Supplier BBBBBB AHU-OIJ-JUH-Supplier CC As you can see the suppliers name are always at the back, how to build the formula just to extract the supplier name (different lenght) that always at the back. Thanks Howard |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| using a conditional suffix in text function format syntax=text(value,format_text) | Excel Worksheet Functions | |||
| Can Text Function change output text color? | Excel Discussion (Misc queries) | |||
| Advanced text function (combining text) | Excel Worksheet Functions | |||
| Using Concatenate function to generate text in Text Box | Charts and Charting in Excel | |||
| Macro or Function to make text size to suite text Length? | Excel Discussion (Misc queries) | |||
Threaded Mode
