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

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

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