| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Text function
=TRIM(RIGHT(SUBSTITUTE(A1,"-",REPT(" ",99)),99))
"Howard" wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Text function
If there is **always** a dash in front of the supplier's name (as you show)
and if your supplier's name **never** has a dash in it, then you can use this formula... =TRIM(RIGHT(SUBSTITUTE(A1,"-",REPT(" ",99)),99)) -- Rick (MVP - Excel) "Howard" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Text function
If you do not want the word "Supplier" try this:
=MID(A6,FIND("er ",A6)+3,99) HTH Regards, Howard "Howard" wrote in message ... 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 |
| Reply |
| 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) | |||
Linear Mode
