| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract Supplier Name
i need to extract the supplier name from my database and the supplier that
downloaded from my system which not in a consistant format: - POK-KIJ-198-BBC Ltd POI-980-Microsoft Ltd IUYOP0987-Seach Pvt Ltd How can i build a formula to extract the supplier name which apparently always at the back of the text? Thanks howard |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Extract Supplier Name
If you look down to the first post you made with this question (you called
the subject "Text function"), you will see the two answers you already got to it. -- Rick (MVP - Excel) "Howard" wrote in message ... i need to extract the supplier name from my database and the supplier that downloaded from my system which not in a consistant format: - POK-KIJ-198-BBC Ltd POI-980-Microsoft Ltd IUYOP0987-Seach Pvt Ltd How can i build a formula to extract the supplier name which apparently always at the back of the text? Thanks howard |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Extract Supplier Name
Try the below
=TRIM(RIGHT(SUBSTITUTE(A1,"-",REPT(" ",255)),255)) -- Jacob "Howard" wrote: i need to extract the supplier name from my database and the supplier that downloaded from my system which not in a consistant format: - POK-KIJ-198-BBC Ltd POI-980-Microsoft Ltd IUYOP0987-Seach Pvt Ltd How can i build a formula to extract the supplier name which apparently always at the back of the text? Thanks howard |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to display price in $ or £ dependant on supplier | Excel Worksheet Functions | |||
| Supplier list | Excel Worksheet Functions | |||
| Subtotal by Month and supplier | Excel Worksheet Functions | |||
| Supplier scorecard | Excel Discussion (Misc queries) | |||
| Select Minimum value and return the name of the supplier | Excel Worksheet Functions | |||
Linear Mode
